When do conversions generate conversion warnings? And why are these bad?

Hello, A few days ago a colleague asked me why was he seeing implicit conversions in the execution plan, but no warnings of such sort were being issued. Warnings are seen in the plan if the conditions they affect occur, and then are surfaced in the <Warnings> element of SHOWPLAN, either as affecting Cardinality Estimates…

0

SQL Swiss Army Knife #15 – Handling duplicate indexes

Hello all, Part of my job is to help customers find and fix performance issues, and this post comes after one such engagement. A customer was using another of the SQL Swiss Army Knife series scripts to find info on indexes on all the databases in a given instance – the one referenced in the…

0

Too many single use plans, now what?

Hello, I’ve been asked the question in title at least twice in the past month, but the question is really incomplete – I would rather be asked “I have too many single use plans taking up a lot of memory in my server, can I do something about it?”. The answer would be the classic…


SQL Swiss Army Knife #13 – Exploring the plan cache – Part 2

Hello all, This is long overdue, but here it is, the follow up on plan cache exploration queries part 1 post. There are many “hidden” gems inside a query plan XML that allow us to know our workloads in greater and better detail. Here are a few more xqueries snippets for various purposes. These are…


SQL Swiss Army Knife #13 – Exploring the plan cache – Part 1

Hello all, In the last few months I’ve been creating a few snippets of code to extract as much useful information from the plan cache as possible. Why to do this? We at Microsoft GBS PFE deliver a type of service called a SQL Performance Tuning and Optimization Clinic, which is directed at finding and…


PAGELATCH_EX waits and heavy inserts

Hello all, Recently I came across an issue over a table that was being inserted into quite intensively, by concurrent operations. The issue, which is not that uncommon, is dealing with PAGELATCH_EX contention, namely when a table has a clustering key that conforms with the concept of a small and monotonically increasing value, such as…


SQL Swiss Army Knife #11.1 – Locking, blocking and active transactions

Latest update: 12/2/2016 (Check change log) Download on GitHub Hello all, Following the series “SQL Swiss Army Knife”, here is another version of this script that I’ve been using and tweaking for years now. This way I can get a quick overview of query execution on a given SQL Server instance, from SQL Server 2005…

3

SQL Swiss Army Knife #8 – Find a Maintenance Window

Hello all, So this another post on SQL scripts for DBAs, following the series “SQL Swiss Army Knife”. This time with a way to “guesstimate” (heard this a while ago) the availability window on a server. Note that this is only usable from SQL Server 2005 onwards. Have you ever needed to find a few…


New white papers for SQL Server were released

Hello, New white papers where published for SQL Server 2008: Consolidation Using SQL Server 2008 High Availability with SQL Server 2008 Using the Microsoft Connector for Oracle by Attunity with SQL Server 2008 Integration Services Using the Microsoft Connector for Teradata by Attunity Response to Oracle’s Edison 2009 Report SharePoint and Reporting Services Integration Troubleshooting…


TDS Parser for NetMon 3.2 and 3.3 (Beta)

It is available a new set of Network Monitor Parsers that include a Microsoft SQL Tabular Data Stream Protocol (TDS) parser: http://nmparsers.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=23966 This new set of parsers are available for the versions 3.2 and 3.3 (Beta) of NetMon. Cheers,