Browse by Tags

SQL Server latch waits - index contention & performance issues how DMVs can help you to get information?

Published 17 April 8 5:6 AM | SSQA.net

What kind of performance issues you see on day-to-day basis within your environment? The following elements are important factors that can add fuel to the fire (problem): Faulty hardware • Hardware that is not configured correctly • Firmware settings...

Filed under: sql server, memory, analysis, disk, IO, monitoring, configuration, iometer, contention, latches, latching

SQL Server has encountered % occurrence(s) of IO requests taking longer than 15 seconds to complete on file

Published 13 July 7 5:25 AM | SSQA.net

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...

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