Other SQL Server Blogs around the Web

Browse by Tags

• backup
• blogs
• cache
• checkpointl
• database
• database mirroring
• disaster recovery
• disk space
• flush
• i/o
• log shipping
• monitoring
• msdn
• multiple
• restore
• single
• sql server
• SQL Server 2008
• tablesample
• Trace Flags
• wait type
• writelog

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

  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... Posted Apr 22 2008, 01:51 PM by SSQA.net Filed under: i/o, sql server, cache, performance, database, backup, msdn, transaction log, monitoring, blogs, checkpointl, flush

• More on Database Mirroring performance and index maintenance

  There's been some discussion over on the SQL Server Central forums about database mirroring performance, and one question in particular on how to do index rebuilds on mirrored VLDBs. Remember that in database mirroring, the database has to be in the... Posted Oct 18 2007, 07:37 PM by SSQA.net Filed under: performance, database mirroring, transaction log

• WRITELOG wait types - what your SQL Server is saying?

  Whenever the SQL Server is struggling to write the transactions to the disk, you would observe WRITELOG wait type within SP_WHO2 results. So when you observer such wait types then you should be worried on the disks performance, either you plan for shrinking... Posted Oct 12 2007, 07:41 AM by SSQA.net Filed under: sql server, performance, disk space, transaction log, wait type, writelog, tablesample

• SQL Server 2008: Performance boost for Database Mirroring

  As I mentioned in a previous post, one of the new features for database mirroring in SQL Server 2008 is log stream compression. There's a good explanation of what this is (along with some example workloads and performance graphs) on the SQL Customer... Posted Oct 10 2007, 07:06 PM by SSQA.net Filed under: SQL Server 2008, Trace Flags, performance, database mirroring, transaction log, disaster recovery

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

  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... Posted Aug 27 2007, 04:51 AM by SSQA.net Filed under: sql server, performance, transaction log, log shipping, multiple, single, restore