Seek or Scan – Cost Based Optimizer in SQL Server

• by administrator

• Ramesh Meyyappan’s SQL Server Performance Tuning Blog

When SQL Server has a choice of plans, it will compare the cost among a set of execution plans and will choose the cheapest one. In some cases, even...

2016-05-15

4 reads

Temp Table Caching in SQL Server

• by administrator

• Ramesh Meyyappan’s SQL Server Performance Tuning Blog

SQL Server caches temporary objects (temporary tables and table variables), that are created in a stored procedure. Temporary objects that are created either in dynamic SQL statement or by...

2016-05-15

2 reads

Tempdb Allocation Contention in SQL Server

• by administrator

• Ramesh Meyyappan’s SQL Server Performance Tuning Blog

In SQL Server, the concurrent creation of temporary objects (temporary tables and table variables) from many sessions can lead to tempdb allocation contention. This contention occurs on PFS and...

2016-05-15

2 reads

Tempdb Metadata Contention in SQL Server – Table Variable Vs Temporary Table

• by administrator

• Ramesh Meyyappan’s SQL Server Performance Tuning Blog

In SQL Server, the concurrent creation of temporary tables from many sessions can lead to tempdb metadata contention. Tempdb metadata contention does not affect the concurrent creation of table...

2016-05-15

5 reads

Understanding ASYNC_NETWORK_IO Waits in SQL Server

• by administrator

• Ramesh Meyyappan’s SQL Server Performance Tuning Blog

In SQL Server, ASYNC_NETWORK_IO wait time can be high due to slow network, like when the database is in the cloud and the application is on premise. Furthermore, it...

2016-05-15

Resource Governor in SQL Server – Workload Throttling

• by administrator

• Ramesh Meyyappan’s SQL Server Performance Tuning Blog

Resource Governor in SQL Server provides CPU, Memory and I/O throttling. In SQL Server 2014 and earlier, CPU throttling works only for similar kind of workloads and not for...

2016-05-14

Data Compression in SQL Server – Pros and Cons

• by administrator

• Ramesh Meyyappan’s SQL Server Performance Tuning Blog

SQL Server supports row and page compression on tables, indexes and partitions. This can lead to reduced I/O and better performance. However, it can also result in additional CPU...

2016-05-10

2 reads

SQL Server Command Timeout – Application Timeout – Attention

• by administrator

• Ramesh Meyyappan’s SQL Server Performance Tuning Blog

When you use ODBC or SqlClient to access data from SQL Server, by default the query will be cancelled if there is no response from the server within a...

2016-05-09

2 reads

My Best Blog Posts from 2015

• by administrator

• Kevin E. Kline

ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in...

2016-02-01

1 reads

My Best Blog Posts from 2015

• by administrator

• Kevin E. Kline

ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in...

2016-02-01

2 reads