Microsoft SQL Server Replication – Not Meant for H/A

Options for HA Configurations? Not Replication! If you’re considering high availability options, replication is not an option.  SQL Server has other H/A options such as Clustering, Mirroring, and AlwaysOn that deal with your RDBMS or database as a whole.  Log Shipping is typically used as a low cost H/A implementation, however, its best used as a secondary [...]

By |2017-09-20T08:32:06+00:00January 21st, 2014|Tips|Comments Off on Microsoft SQL Server Replication – Not Meant for H/A

Microsoft SQL Server Query Plan Warning Signs

When looking at a query plan (QP) in SQL Server Management Studio (SSMS), it can be overwhelming and confusing.  People often ask, “What do I look for?” and “Where do I start?”  There are several warning signs that your query is performing poorly.    Below we’ll take a look at some of the most common types. [...]

By |2017-09-20T08:39:49+00:00October 3rd, 2013|Performance Wire|Comments Off on Microsoft SQL Server Query Plan Warning Signs

Microsoft SQL Index Hints

The Microsoft SQL Server query optimizer is a cost based optimizer.  This means it will determine the best method to execute your SQL command based on information that it has about the database objects.  At times, the optimizer does not know best and you need to give a hint to nudge it in the [...]

By |2017-09-20T08:40:36+00:00October 2nd, 2013|Tips|Comments Off on Microsoft SQL Index Hints

Microsoft SQL on the Azure Cloud? The time might be right.

Deciding which type of SQL Server configuration to deploy can be a challenging process.  The addition of Windows Azure creates an additional possibility to consider versus an in-house configuration.  Microsoft offers a cloud option for SQL Server as part of the Windows Azure product.  The two general options are the “SQL Database” service or [...]

By |2017-09-20T08:41:42+00:00September 20th, 2013|Out Perform|Comments Off on Microsoft SQL on the Azure Cloud? The time might be right.

Troubleshooting outside the Microsoft SQL Server

How default application driver settings may cause performance problems At PTC, we have noticed an interesting performance issue concerning the JDBC application driver.  There have been several clients coming to us with SQL Server performance problems that they could not resolve on their own.  Their SQL Servers were showing a consistently high amount of [...]

By |2017-09-20T08:44:54+00:00September 20th, 2013|Performance Wire|Comments Off on Troubleshooting outside the Microsoft SQL Server