Browse by Tags

• analysis
• benchmarking
• best practice
• cpu
• dba
• disk space
• dmv
• hardware
• i/o
• indexes
• memory
• monitoring
• object
• optimization
• raid
• reindexing
• san
• scsi
• security
• sorting
• spindle
• sql server
• ssms
• tuning
• type
• wait

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

Filed under: performance, sql server, raid, hardware, disks, best practice, monitoring, benchmarking, san, scsi

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

Filed under: performance, sql server, indexes, optimization, dba, hardware, disks, best practice, reindexing, disk space, sorting

ASYNC_NETWORK_IO: query is slow
29 August 07 03:00 AM | SQL Master | 2 Comments   

When you run normal SELECT statement from the Activity Monitor, the session has a status of "suspended", a command of "SELECT" and a wait type of "ASYNC_NETWORK_IO". What do you expect to the see the results and within the column status, we will see quite Read More...

Filed under: tuning, performance, sql server, wait, object, i/o, disks, type

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

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

Filed under: performance, sql server, security, hardware, spindle, disks