Browse by Tags

All Tags » performance » hardware   (RSS)
SQL Server Memory - what's your method on Configuration and Troubleshooting Issues
01 April 08 02:49 AM | SQL Master | 5 Comments   
Memory - an important aspect of system performance within a RDBMS platform, not specific to a database product or application. Coming to Microsoft related products such as Windows Server and SQL Server so on, various resources available on web such as Read More...
Best way to deploy SQL Server 2005 with SAN
28 January 08 01:01 AM | SQL Master | 6 Comments   
If it is a first time you are deploying the SQL Server 2005 on a SAN, then there are few things you need to be considered that will be raised by installations that are either deploying SQL Server for the first time or are upgrading to SAN from direct Read More...
Is RAID5 better for performance when SQL Server Clustering and SAN is involved?
22 January 08 11:28 PM | SQL Master | 8 Comments   
One of the recent usergroup meeting brought an interesting question that "what type of hardware I need for a RAID-5 Shared Array for SQL Server Cluster"? By default RAID5 hardware controller is best to hold as not to go with software RAID5 as it will Read More...
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...
Disk Space Requirements for Index DDL Operations
28 September 07 06:38 AM | SQL Master | 3 Comments   
Are you watching your disk space during the indexes operations where these database objects are stored? Recently I was stumped on a database that is only 5GB had reindexing process failure due to 10% of disk free space was available. For your information Read More...
DMVs to provide state of TEMPDB during a performance tuning analysis
14 August 07 06:55 AM | SQL Master | 5 Comments   
TEMPDB - though the name sounds like temporary database, it most important for any user database! Coming to performance tuning exercise or analysis you would go through Task Manager initially to see how system's memory & processor are coping up. Though Read More...
Smaller disks <> more spindles which one is better for performance?
10 August 07 02:53 AM | SQL Master | 2 Comments   
I have gone through a question within the forums asking "smaller disks or more spindles" which is better for performance. The simple answer is more disks to handle the data growth and also mostly depends upon the number of transactons that are handled Read More...
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...

Search

Go

This Blog

«December 2008»
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Syndication