Monday, August 20, 2007

Update stats on database with Read only

sp_updatestats would fail if a database on "Read Only" with below error

Server: Msg 3906, Level 16, State 1, Line 1
Could not run BEGIN TRANSACTION in database 'doctrack' because the database is read-only.
Updating dbo.doclink1

Sunday, August 19, 2007

SQL Server Performance Audit Checklist

Identify SQL Server Hardware Bottlenecks
Performance Audit Checklist

Counter Name Average Minimum Maximum
Memory: Pages/sec

Memory: Available Bytes

Physical Disk: % Disk time

Physical Disk: Avg. Disk Queue Length

Processor: % Processor Time

System: Processor Queue Length

SQL Server Buffer: Buffer Cache Hit Ratio

SQL Server General: User Connections