About Alex Stamenkovich

This author has not yet filled in any details.
So far Alex Stamenkovich has created 7 blog entries.

SQL Server 2014 Cardinality Estimator

Cardinality Estimator Microsoft SQL Server has implemented a significant change to the database engine’s Optimizer with the introduction of an improved Cardinality Estimator in version 2014. The Optimizer component has not changed since version 7 (about 15 years). This represents a significant update and can potentially provide your environment with a huge performance boost. [...]

By |2017-09-20T08:27:01+00:00October 22nd, 2014|Performance Wire|Comments Off on SQL Server 2014 Cardinality Estimator

Using Extended Events to Troubleshoot Query Performance

SQL Server 2014 Extended Events This article will focus on how using SQL Server 2014 Extended Events can be used to troubleshoot query performance. It is not meant as a complete tutorial of how to use Extended Events, rather a demonstration. SQL Server 2014 Extended Events is not necessarily a new feature of SQL Server. [...]

By |2017-09-20T08:28:17+00:00October 15th, 2014|Performance Wire|Comments Off on Using Extended Events to Troubleshoot Query Performance

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