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
Monday, August 20, 2007
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
Subscribe to:
Posts (Atom)