THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance   (RSS)
Showing page 4 of 19 (187 total posts)
  • Performance Tuning with SQL Server Dynamic Management Views

    From Red-Gate website you can download (for free) the ebook Performance Tuning with SQL Server Dynamic Management Views written by Louis Davidson (@drsql) and Tim Ford (@sqlagentman). DMVs are objects that publish information about the health state of a SQL Server instance. They allow you to monitor the heart of the system to diagnose ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 14, 2014
  • Using whoami to check for instant file initialization

    Read this if you want to read more about instant file initialization (IFI). In an earlier blog post, I posted a script that uses trace flags, created a dummy-database and then sp_readerrorlog to check for IFI. Another option is to use the OS command whoami, as documented here. Below script uses whoami to check for IFI, or more precisely SQL ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 12, 2014
  • How often do you rebuild your heaps?

    Never? You are not alone. None of the maintenance solutions I use includes functionality to rebuild a heap, and that includes Maintanance Plans and Ola Hallengren's maintenance solution. ''So why would you want to rebuild a heap, when it isn't sorted in the first place?'', you ask. The answer is to get rid of Forwarding Pointers, and these can ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 6, 2014
  • Setting max server memory

    If there is one server setting that is close to universal to configure, then it is probably the ''max server memory'' setting. The setting is documented here. There are plenty of articles out there on this subject. The purpose for this article is for me to have somewhere to point when I get the question: ''What value should I set this to?''. I ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 6, 2014
  • Updated File & Wait Statistics Procedures

              Please note that I have a newer version of these procedures that you can find herehttp://sqlblog.com/blogs/andrew_kelly/archive/2015/09/02/revised-file-wait-statistics-procedures.aspx .  For many years I have been using a set of stored procedures to capture and report on both ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 13, 2014
  • Do you want improved performance?

    Can you survive a few lost transactions if your server does a ''hard shutdown''? If so, check out SQL Server 2014 and ''Delayed Durability''. A cornerstone in SQL Server's transaction handling has up until 2014 been ''durability'' for a committed transaction. Durability is by the way the ''D'' in the ACID acronym: Atomicity, Consistency, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on February 13, 2014
  • One Preparation that makes SSMS Crash Dumps Easy to Survive

     Uh oh!So you're plugging along in SQL Server Management Studio (SSMS) when it suddenly goes belly up. Now you're staring at various dialog boxes telling you that SSMS crashed. Usually the first dialog box you get will ask you if you'd like to close OR the program. If you choose to close the program, you'll be presented with the opportunity ...
    Posted to Kevin Kline (Weblog) by KKline on February 10, 2014
  • Check for Instant File Initialization

    Instant File initialization, IFI, is generally a good thing to have. Check out this earlier blog post of mine f you don't know what IFI is and why it is a good thing: blog. The purpose of this blog post is to provide a simple script you can use to check if you have IFI turned on. Note that the script below uses undocumented commands, and might ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 30, 2013
  • Wait Statistics in Microsoft SQL Server

     (Originally appearing at http://kevinekline.com/2013/10/09/wait-statistics-in-sql-server/).When it comes to troubleshooting in relational databases, there's no better place to start than wait statistics.  In a nutshell, a wait statistic is an internal counter that tells you how long the database spent waiting for a particular ...
    Posted to Kevin Kline (Weblog) by KKline on October 9, 2013
  • Stats on Stats

    I have been working on new features for the Rules-Driven Maintenance Solution, including per-index maintenance preferences and more selective processing for statistics. SQL Server stats is a topic I knew about at a high level, but lately I have had to take a deeper dive into the DMVs and system views and wrap my head around things like ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on September 18, 2013
« First ... < Previous 2 3 4 5 6 Next > ... Last »
Privacy Statement