Browse by Tags

Blog do Ezequiel
Portuguese PFE SQL Server Team


  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: SQL Swiss Army Knife #11.1 - Locking, blocking and active transactions

    EDIT (12-04-2013): Added page type information (PFS; GAM or SGAM) when wait type is PAGELATCH_ or PAGEIOLATCH_ . EDIT (23-05-2013): Fixed parse page issue. EDIT (17-10-2013): Added memory grant info, statements to blocking and blocked sections of blocking report, and fixed head blocker info. ...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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,
  • Blog Post: SQL Nexus 2.5.0.7 released

    Hi, A new version of the tool - SQL Nexus (2.5.0.7) was released: http://sqlnexus.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=23339 Release Notes Most fixes are related to silent or batch processing 1) Adjusted CurrentDB text box for auto-complete and copy and paste database name 2) Enhanced...
  • Blog Post: RML Utilities, version 9.01 Released

    A new version of the RML Utilities for SQL Server, version 9.01, was released (with support for SQL Server 2008): http://blogs.msdn.com/psssql/archive/2008/11/12/cumulative-update-1-to-the-rml-utilities-for-microsoft-sql-server-released.aspx Review, also, the last minute update regarding a small...
Page 1 of 1 (10 items)