Browse by Tags

• best practice
• blogs
• dbcc
• defrag
• disk space
• diskkeeper
• disks
• dmv
• file
• i/o
• indexes
• monitoring
• query
• showcontig
• sql server
• tuning
• type
• wait

What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?
26 March 08 01:01 AM | SQL Master | 5 Comments   

Fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation, what about the physical level fragmentation? So what is the best Read More...

Filed under: performance, sql server, dbcc, object, best practice, defrag, showcontig, blogs, disk space, monitoring, diskkeeper, file

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

Get a blocking list for the objects & indexes using DMV
13 June 07 07:44 AM | SQL Master | 6 Comments   

Yet another help from DMV I would like to share here, say on a SQL Instance you are getting low-level I/O and blocking intermittently. For the I/O issues using SYSMON (PERFMON) is ideal to get more information during the busy times and low-usage times Read More...

Filed under: performance, sql server, query, dmv, indexes, object