More in Database Performance Tuning

  • SQL Server acceptance testing at a desk
    Mar 17, 2014
    blog

    SQL Server Acceptance Testing: A Subtle Trick

    For people who are simply too busy to tackle much needed SQL Server acceptance testing, I've found that a key way to tackle this is to simply schedule a one hour meeting with them—at their desk....More
  • database digram
    Feb 25, 2014
    blog

    Using Cache to Save $200,000

    Recently, I've been working with a consulting client to help them tame CPU usage. Typically, they're clocking over 20,000 queries and operations per second on their e-commerce SQL Server, but ran into an issue where CPU started spiking up above 90 percent for sustained periods of time....More
  • 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

From the Blogs
Dec 16, 2014
Sponsored

Eight SQL Server Signs the Illuminati Exist

Make no mistake about it, the signs that the Illuminati exist are all around us. You can find their markings on our buildings, on our currency and even in our music videos. That’s right, they’re everywhere!...More
Dec 2, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 16: Job Synchronization Checkup Logic

With Linked Servers configured to allow cross-host or cross-box communication between the servers you’re using to host your AlwaysOn Availability Groups, it’s time to start looking at some scripts that can be used to regularly check whether or not SQL Server Agent jobs are correctly synchronized across all servers in your topology....More
Abstract illustration of linked SQL Servers
Nov 18, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 15: Setting Up Linked Servers

Learn about setting up Linked Server definitions to let two (or more) servers in an AlwaysOn Availability Group talk to each other and check up on job statuses of jobs running on each other....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) ×