Browse by Tags

SQL Server databases - checkpoint, cache and I/O request - what you need to know?

Published 22 April 8 1:51 PM | SSQA.net

Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes...

Filed under: sql server, performance, msdn, backup, blogs, database, transaction log, cache, i/o, flush, monitoring, checkpointl

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

SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?

Published 29 February 8 4:4 AM | SSQA.net

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

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