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

What should I choose Load Balancing or Data Partitioning?

Published 12 September 7 5:42 AM | SSQA.net

One of our client had such requirement to cater a load balancing for their application and needed to upgrade to higher versions of SQL Server & Operating systems. The current setup at their end is a SQL Server 2000 Active/Passive Cluster and the transactions...

Filed under: sql server, performance, high availability, tuning, replication, active/passive, latency

Whats the best way to setup memory on a four-node cluster?

Published 6 September 7 4:42 AM | SSQA.net

Though it is more to do with SQL Storage kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances...

Filed under: sql server, performance, analysis, high availability, ssis, security, ssas, ssms, clustering, resources

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

BI - PerformancePoint Server LAST CTP announced!

Published 16 August 7 10:32 AM | SSQA.net

Microsoft released PerformancePoint Server’s LAST Community Technical Preview (CTP) before launch! To date, the CTP program has gathered close to 10,000 members and the product has been enjoying fantastic pre-launch press and analyst coverage. For more...

Filed under: sql server, performance, high availability, bi, bids, performancepoint