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