Browse by Tags

SQL Server data and log files initialization, think multiple files, backup & restore performance!

Published 25 July 8 6:1 AM | SSQA.net

Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh. In addition to this when you talk about files intialization...

Filed under: sql server, performance, restore, best practices, multiple, filegroup, backups, disks, throughput, files, tapes

SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?

Published 8 May 8 3:42 AM | SSQA.net

When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By...

Filed under: sql server, performance, high availability, best practices, cluster, support, database mirroring, instances, multiple, failover, scalability

Multiple transaction log backups or Single transaction log backup file, which is better?

Published 27 August 7 4:51 AM | SSQA.net

Say which is better, having multiple transaction log backups files or single transaction log backup file during a recovery point of time. In my experience both of them doesn't make any difference and if you are performing further backup to tape then...

Filed under: sql server, performance, restore, transaction log, multiple, log shipping, single

SQL Server consolidation & keeping up performance at the same time

Published 15 June 7 4:3 AM | SSQA.net

So what are your options in Server consolidation and not to harm the performance for the applications that are happily sitting across your data center and you have this mammoth task to consolidate the servers to save physical space etc. No doubt that...

Filed under: sql server, performance, management, consolidation, instances, multiple, planning