Browse by Tags

• benchmarking
• best practice
• clustered
• clustering
• dbcc
• defrag
• disk space
• diskkeeper
• environment
• file
• object
• performance
• san
• showcontig
• sql server

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

SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?
29 February 08 03:04 AM | SQL Master | 4 Comments   

Another FAQ within newsgroups & forums that will SQL Server Clustering supports load balancing? It is quite common for a newbie to say and look at Clustering configuration such as Active-Active where you have n+1 nodes as a serving instances, the Read More...

Filed under: performance, sql server, clustered, best practice, clustering, blogs, monitoring, environment, benchmarking, san