Browse by Tags

• analysis
• backup
• best
• clustersize
• configuration
• contention
• cpu
• hardware
• indexed view
• indexes
• IO
• iometer
• latches
• latching
• lun
• memory
• microsoft
• monitoring
• partition
• performance
• raid
• read
• request
• sql server
• storage
• subsystem
• taking longer
• technet
• testing
• tool
• worst
• write

SQL Server latch waits - index contention & performance issues how DMVs can help you to get information?
17 April 08 03:06 AM | SQL Master | 2 Comments   

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

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

NTFS Cluster size - if changing the default cluster size on the disk is a good idea or not?
16 October 07 05:18 AM | SQL Master | 2 Comments   

You might have come across on the web resources that setting the disk to a 64k cluster size (8 * 8KB pages) might achieve the performance. But have you wondered will this really boost the disk performance, see in what scenario such as lots of reads and Read More...

Filed under: performance, sql server, microsoft, disk, testing, hardware, technet, lun, clustersize, partition

Best and Worst of having indexed views in SQL 2005
30 July 07 08:15 AM | SQL Master | 7 Comments   

Consider to have indexed view if the queries are accessing using a f requently occurring aggregations and joins. Irrespective of whether or not a query is asked frequently, it may be a candidate for an indexed view if it takes significant time to answer, Read More...

Filed under: performance, disk, indexed view, worst, best

How to gain Disk related performance with few simple steps
30 July 07 07:24 AM | SQL Master | 4 Comments   

Within your SQL Server environment there are few simple steps you can take up in order to gain performance to a level, for instance when configuring a SQL Server that will only contain a few gigabytes (GB) of data and not sustain heavy read nor write Read More...

Filed under: performance, sql server, microsoft, indexes, disk, raid, IO, testing, hardware, tool

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: performance, sql server, memory, disk, cpu, taking longer, IO, subsystem, request

Battery backup write cache for controllers - should it be disabled?
22 May 07 08:03 AM | SQL Master | 0 Comments   

You might be aware that now a days many high-end and high-spec disk subsystems provide high-speed cache facilities to reduce the latency of read and write operations. In general this cache is supported by a battery-power backup facility, which is necessary Read More...

Filed under: performance, read, write, disk, storage, backup