Browse by Tags

All Tags » disk (RSS)
SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?
Published 28 April 8 3:1 AM | SSQA.net
You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based...
Filed under: , , , , , , , , , ,
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 configuration disk layout - best practices from field
Published 3 April 8 3:17 AM | SSQA.net
Configuration of server such as disk and memory is an important factor for SQL Server Performance, there is all about questions within newsgroups and forums that how do I setup the disk layout for a SQL Server database (say, 2005 version). Not only this...
Filed under: , , , , , , , , ,
SQL Server 2008 Resource Governor FAQ
Published 25 February 8 1:36 AM | SSQA.net
Bottlenecks aka locking & blocking is a quite common scenario within a RDBMS platform, that too SQL Server is not an exception at all. With an access to shared resources causes bottlenecks and demands on shared resources cause poor response time and...
Filed under: , , , , , , , , , , ,
Relation between SQL Server 2005 and Volume Shadow Copy services?
Published 19 February 8 2:45 AM | SSQA.net
Until last month I was not aware about Volume Shadow Copy and what is the relation between that service & SQL Server services, so here I would like to give the information in this regard that will discuss SQL Server connection issues that you may...
Filed under: , , , , , , , ,
Improving Backup and Recovery RTO RPO in a SAN - think on your SQL Server environment
Published 6 December 7 12:47 PM | SSQA.net
Backup and restore practices are at the core of today's best business continuity plans. While backup and restore provides many benefits, it simultaneously presents a variety of challenges with lost data, the time it takes to restore data, and the...
Filed under: , , , , , , , ,
NTFS Cluster size - if changing the default cluster size on the disk is a good idea or not?
Published 16 October 7 7:18 AM | SSQA.net
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...
Filed under: , , , , , , , , ,
Best and Worst of having indexed views in SQL 2005
Published 30 July 7 10:15 AM | SSQA.net
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...
Filed under: , , , ,
How to gain Disk related performance with few simple steps
Published 30 July 7 9:24 AM | SSQA.net
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...
Filed under: , , , , , , , , ,
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: , , , , , , , ,
Mount Points and Clustering blurb for SQL Server & windows operating system
Published 25 May 7 6:18 PM | SSQA.net
Mount Point is the new concept introduced in the Windows 2003 Server (R2) that works as a mounted drive is a volume or a drive that is mapped to a folder on a volume that uses the NTFS file system. Mounted drives function as any other volume or drive...
Filed under: , , , , , ,
Snapshot backups - do I need equivalent database size disk space?
Published 23 May 7 3:17 AM | SSQA.net
Snapshot backups are introduced in SQL Server 2005 version that uses: The underlying backup technology creates an instantaneous copy of the data that is being backed up. The instantaneous copying is typically accomplished by splitting a mirrored set of...
Filed under: , , , , , ,