Browse by Tags

• analysis
• cache
• databases
• dbcc shrinkfile
• disk
• disks
• dmv
• huge
• indexes
• IO
• monitoring
• operating system
• performance
• request
• sql server
• ssms
• subsystem
• taking longer

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?
25 April 08 01:30 AM | SQL Master | 2 Comments   

In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases Read More...

Filed under: sql server, cache, memory, indexes, databases, cpu, monitoring, operating system, huge, dbcc shrinkfile

sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!
17 August 07 06:04 AM | SQL Master | 3 Comments   

The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any Read More...

Filed under: ssms, performance, sql server, dmv, memory, cpu, disks, analysis

SQL Server has encountered % occurrence(s) of IO requests taking longer than 15 seconds to complete on file
13 July 07 03:25 AM | SQL Master | 1 Comments   

By now you should have applied the Service Pack 4 on your SQL Server 2000 instances and you might come across the message within the SQL error log " SQL Server has encountered 5877 occurrence(s) of IO requests taking longer than 15 seconds to complete Read More...

Filed under: request, performance, sql server, memory, disk, cpu, taking longer, IO, subsystem