Browse by Tags

• best practice
• blogs
• defrag
• disk space
• diskkeeper
• file
• fragmentation
• index
• indexes
• max worker threads
• microsoft
• monitoring
• object
• resources
• security
• server
• showcontig
• sql server
• sqlperf
• system
• table
• testing
• troubleshoot
• tuning

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

If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?
15 November 07 08:41 AM | SQL Master | 2 Comments   

Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must Read More...

Filed under: tuning, performance, sql server, microsoft, server, dbcc, testing, best practice, resources, max worker threads, sqlperf, system

Rebuild some fragmented indexes - problem with Extent Scan Fragmentation value
24 August 07 04:24 AM | SQL Master | 2 Comments   

This was the question from SSP forums, I’m trying to rebuild few fragmented indexes on a table that is updated on regular basis. The “dbcc showcontig” gave this result: Table: 'Confidential' (999999999); index ID: 5, database ID: 5 LEAF level scan performed. Read More...

Filed under: performance, sql server, security, table, dbcc, fragmentation, index, defrag, showcontig

Index fragmentation and DBCC SHOWCONTIG in SQL Server 2005!
03 July 07 02:55 AM | SQL Master | 0 Comments   

In SQL Server 2005 Dynamic Management Views (DMV) & DM Functions (DMF) allows you the look inside the server to return the required information. It will also helps you to monitor the server instance health and performance to diagnose the problem. Read More...

Filed under: performance, security, indexes, dbcc, fragmentation

How to detect a table fragmentation?
29 May 07 06:02 PM | SQL Master | 2 Comments   

In SQL 2000 version days you could take help of DBCC SHOWCONTIG statement, but this is deprecated in SQL Server 2005, so how to go about it. You can take help DMVs & DMFs in this case, DMV - Dynamic Management View and DMF - Dynamic Management Function, Read More...

Filed under: performance, troubleshoot, table, dbcc, fragmentation