More in Database Performance Tuning

  • computer keyboard with blue tool key
    Sep 18, 2012

    Don't Forget about Backup Compression

    I recently ‘inherited’ a couple of SQL Servers for a client – running SQL Server 2008 (Enterprise Edition). In the process of ‘taking over’ these boxes I’ve scrutinized a number of jobs and details – including backups....More
  • performance check list
    Sep 13, 2012

    Performance Tip: Find Your Most Expensive Queries

    One thing I’m asked on a regular basis when working with SQL Server Consulting clients that don’t have much experience with performance tuning, is how to find what their most expensive queries are. Only, the problem is that the answer to that question can be a bit more complex than you might think....More
  • Jul 25, 2012

    DBAs and Windows Event Logs

    While watching a military documentary with my son the other night, I was struck by just how crazy it is that snipers need to account for wind. I mean, yeah: I get it – they’re shooting at targets that are ridiculously far away and I’ve known for a long time that they have to account for wind....More
  • Geese running
    Jun 27, 2012

    Filtering out benign waits

    The simple answer is that not all waits need to be analyzed when doing performance troubleshooting....More
  • multicolored ethernet network cables
    Jun 20, 2012

    Altering execution priority using Resource Governor

    Most people know that Resource Governor allows you to specify CPU and memory limits when contention for these resources occurs, but it’s a little-known fact that you can configure relative priorities as well....More
  • blue computer keyboard Delete key
    Jun 14, 2012

    How record DELETEs can cause index fragmentation 2

    Record deletion can indeed cause fragmentation. There are two kinds of fragmentation described by SQL Server Books Online: logical fragmentation and low page density....More
  • May 31, 2012

    SQL Server Database Corruption, Part XII: Recovery Sample 2

    In my last post in this ongoing series on SQL Server database corruption I mentioned that my next post would be to provide a ‘soup to nuts’ sample or example of how you can test corruption and recovery in your own environment – as a means of better getting familiar with exactly what corruption is, what it looks like, and how to address it....More
  • May 16, 2012

    Curious Case of the missing SOS_SCHEDULER_YIELD waits 1

    Many of the monitoring scripts/tools for looking at wait statistics aggregate all the wait statistics and return the top 95% of all waits occurring, sorted by most prevalent waits by total wait time....More
  • Apr 17, 2012

    How to prevent table scans when searching LOB data? 2

    If a SELECT has the LOB column in the WHERE clause then the query plan will involve a table scan – as you cannot create a nonclustered index over a LOB column....More
  • Apr 3, 2012

    What about moving LOB data while keeping the table online?

    Moving LOB data associated with a table isn't simple—even with the SQL Server 2012 ability to rebuild indexes that include LOB data as an online operation. The key reason is the behavior of LOB data during these operations....More
  • illustration of data cube with red arrows indicating movement
    Mar 21, 2012

    What about moving LOB data? 2

    There are actually a couple of ways to move LOB data associated with a table. Let's tackle moving LOB data using OFFLINE operations....More
  • Mar 13, 2012

    Setting permissions on a database mirror database snapshot 2

    The only way to access the data in a mirror database is to create a database snapshot on the mirror database and then have users connect to the database snapshot to run their queries....More
  • Mar 7, 2012

    Do query plans take account of what data is in memory?

    When the query optimizer is evaluating various plans as it narrows down the possible choices for the best plan it can come up with in a reasonable time (which is not always the absolute best plan, as the query optimizer cannot spend an inordinate amount of time doing plan compilation), it makes use of the relational metadata....More
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Baby duck swimming alone
Jul 15, 2014

The Marginalization of SQL Server Standard Edition 5

Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More
Jul 8, 2014

Replication: Sometimes More is Less

The unconventionality of having two publications for complex, unruly databases typically ends up saving huge amounts of time over the long haul and makes replication much easier to manage....More
Red restore key on computer keyboard
Jun 24, 2014

AlwaysOn Availability Groups and Third Party Log Readers

When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery concerns from a single interface or set of tooling, thus providing better scalability of management....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×