Browse by Tags

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

Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?

Published 12 December 7 12:7 PM | SSQA.net

While we were in Barcelona we sat down with Richard Campbell and Greg Hughes from RunAs Radio to record a 1/2 hour interview on SQL Server 2008. We touch on a ton of different features (look at the number of Categories I've tagged this with!) and...

Filed under: performance, tools, replication, disaster recovery, dmf, database mirroring, encryption, compression, SQL Server 2008, Indexes From Every Angle, Database Maintenance, Interviews, Page Checksums, Backup/Restore, Conferences

Tuning options for SQL Server 2005 that is running in high performance workloads

Published 22 November 7 4:28 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: performance, database mirroring, workload, sql serverkba, high performance

Conference Questions Pot-Pourri #4: How many databases can you *really* mirror per instance?

Published 9 November 7 5:58 PM | SSQA.net

This is a question I was asked multiple times over the last week: the Microsoft guidelines for database mirroring say not to mirror more than 10 databases per instance - why is that and is it true? The answer is my favorite 'it depends!'. The...

Filed under: performance, database mirroring, Conference Questions Pot-Pourri

More on Database Mirroring performance and index maintenance

Published 18 October 7 7:37 PM | SSQA.net

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

Filed under: performance, transaction log, database mirroring

SQL Server 2008: Performance boost for Database Mirroring

Published 10 October 7 7:6 PM | SSQA.net

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

Filed under: performance, transaction log, disaster recovery, database mirroring, SQL Server 2008, Trace Flags

SQL Server 2008: New Performance Counters for Database Mirroring

Published 1 October 7 3:31 PM | SSQA.net

Part of the improvements to Database Mirroring in SQL Server 2008 are the addition of 10 new performance counters under the Database Mirroring Performance Object. These add some cool troubleshooting capabilities. SQL Server 2005 provided the following...

Filed under: performance, database mirroring, SQL Server 2008

Number of databases limit for Database Mirroring within X64 environment?

Published 30 August 7 5:27 AM | SSQA.net

We have had a request from one of the solutions company stating they have to mirror 15 SQL Servers that are dispersed across the European locations to a central location. For this they have deployed the X64 environment for operating system and SQL Server...

Filed under: sql server, performance, high availability, server, database mirroring, x64, geographic