Browse by Tags

What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?

Published 26 March 8 3:1 AM | SSQA.net

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

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

ASYNC_NETWORK_IO: query is slow

Published 29 August 7 5:0 AM | SSQA.net

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

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

Get a blocking list for the objects & indexes using DMV

Published 13 June 7 9:44 AM | SSQA.net

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

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