SharePoint Document Locked by Oneself

Have you ever locked a document in SharePoint unknowingly? This happens when one edits a document directly from the site and one of the following happens:

• Network goes down
• Office client application crashes
• SharePoint site goes down

When this happens, you will not be able to overwrite the document as the document had been "locked" by you "for editing"!

There is no known way of unlocking the document.

The solution is to wait-it-out (see http://support.microsoft.com/kb/899709). Wait for 10 minutes for the server to auto unlock the document.

Monitoring & Troubleshooting ASP.NET Applications on IIS

Toolbox for the IIS server

1. net start
   
2. sc query
   
3. tasklist /svc
   
4. netstat –ano
   
5. wfetch/ wget/ curl
   
6. procmon/ filemon/ regmon
   
7. eventvwr
   
8. mmc.exe (reliability & performance monitoring)
   1. process time & %
      
   2. .NET CLR
      
   3. ASP.NET
      1. Requests Wait Time
         
      2. Requests Current
         
      3. Requests Queued
         
      4. Requests Rejected

Toolbox for the browser machine

1. ping
   
2. telnet/ portcheck
   
3. wfetch/ wget/ curl

When should application pools be turned into web gardens?

Web gardens can only be used if the application doesn’t use in-process session variables but rather out-of-process ones (e.g. session state service or database session state). Drivers to using web gardens are:

1. Application makes long-running synchronous requests
   
2. Application is low in availability and crashes often
   
3. Application creates high CPU load on work process

Non-IIS Settings & Bottlenecks

1. Optimum paging file size setting:
   1. 1.5x the RAM for 32-bit OS
      
   2. system-managed for 64-bit OS
2. Disk queue length should always average less than 2
   
3. Network utilisation should be less than 50%

Take-Home Notes from Seminars

Emerging Technologies

• Cloud – for starters, for for non-business critical functions like CRM, email, collaboration
• Collaboration
• User experience
• Data deluge – what to do with so much data?

Top Business Prioritises

1. Business process improvement
2. Reduce enterprise costs
3. Increase use of information & analytics
4. Improve workforce effectiveness
5. Attract & retain new customers

Business Intelligence

State of Business Intelligence today – 20% of users in an organisation have BI in place; 80% of users do not.
BI Solution Architecture

1. Source system
2. ETL processes
3. Data Warehouse solution (ODS, Staging, Analysis cubes)
4. Report presentation

Microsoft Business Intelligence Strategy

1. Familiarity – Office integration
2. Collaborative – SharePoint integration
3. Manageability – MS SQL

Data Warehouse

Trends in Data-Warehouse

1. Increase in volume
2. Reduce cost
3. Adoption of appliances
4. Move into MPP
5. Desire for real-time analytics
6. Realisation of the importance of data quality

Microsoft DWH Strategy

1. Low TCO for massive scalability – SQL 2008 R2
2. Hardware flexibility – Fast track data warehouse
3. Improved business agility & alignment – Parallel data warehouse (need to consider when data reaches 50TB)

Source system –> Data Warehouse –> SharePoint (report dissemination)

Miscellaneous

Information Workers spend 48% of time searching & analysing information.
Customer centricity

Customer	Anonymity	Awareness	Knowledge	Insight	Intimacy
Capabilities		Reporting	Score-carding	Data-mining	Closed-looped analytics
Goals		Understanding	Improvement	Loyalty	Partnership