More in Database Performance Tuning

  • virus detected message on computer screen
    Dec 19, 2013
    blog

    Another Reason to Avoid Anti-Virus on SQL Server

    If you install anti-virus on SQL Server, many 'bigger' anti-virus vendors either offer 'options' that let them 'monitor' SQL Server—or just plain FORCE their binaries right into SQL Server if they detect that it's running on the box....More
  • Oct 22, 2013
    blog

    Other Tools For Measuring I/O? 1

    There are a few different ways to monitor the I/O workload of a server. The easiest for the database administrator to use will always be Performance Monitor because that is built into the Windows OS....More
  • man in a datacenter explaing sql server performance
    Oct 22, 2013
    blog

    Creating Simple Performance Baselines with SQL Server Profiler

    Use SQL Server Profiler to create a performance baseline and then measure performance metrics that you can compare against the baseline....More
  • database related words
    Sep 24, 2013
    blog

    Truncating SQL Server Job History 1

    A common maintenance task that many 'reluctant DBAs' commonly overlook is the need to keep historical information in the msdb database trimmed, or 'truncated' on a semi-regular basis....More
  • Aug 27, 2013
    blog

    SQL Server Tip: Assign Ownership of Jobs to the SysAdmin Account

    For most of your SQL Server Agent jobs, make sure that as the jobs are created or modified, that you specify that 'sa' (or the built-in SysAdmin) account is the job owner....More
  • Aug 1, 2013
    blog

    Massive Speed and High Availability

    One of the things people are always trying to figure out is how to get high-speed disks and high availability (HA) all in a single package. A possible solution is the DataKeeper Cluster Edition from SIOS Technology....More
  • traffic orange hazard lights
    Jul 18, 2013
    blog

    Tracking Live SQL Server File Stalls

    Given that SQL Server workloads are commonly I/O bound, a great way to get a sense for how a given server is keeping up with its current workload is to evaluate how long the I/O subsystem is taking to respond to requests....More
  • Microsoft SQL Server Profiler output screen
    Jun 25, 2013
    blog

    Debugging (Nested) Stored Procedures with SQL Server Profiler 2

    Nested stored procedures (or stored procedures that call other stored procedures) are a mixed blessing and a curse. They also serve as powerful fodder for starting holy wars....More
  • SQL Server database planning benchmarks
    Apr 22, 2013
    blog

    Read the New TPC Database Benchmarking Series

    Let's talk about database application benchmarking. This is a skill set which, in my opinion, is one of the major differentiators between a journeyman-level DBA and a true master of the trade....More
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Two women looking a man's computer monitor
Sep 17, 2014
Article

AlwaysOn Availability Groups and SQL Server Jobs, Part 6: High-Level Options and Rationale for Handling Batch Jobs

There are a couple of options for how we could handle batch jobs when Availability Groups are thrown into the mix....More
Sep 12, 2014
Sponsored

Managing a Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
Exclamation marke on yellow road sign
Sep 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 5: Setting Up Failover Alerts

Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....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) ×