THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 38 (378 total posts) < 1 second(s)
  • re: The SQL Hall of Shame

    Haha, that was a trip down memory lane! Thanks for the amusing reading Adam, and those who commented. Made me fire up a VM with 6.5 and browse through BOL - many things are no longer there... :-)
    Posted to Adam Machanic (Weblog) by TiborKaraszi on June 20, 2017
  • Logging wait stats over time

    We all know how valuable wait statistics can be when doing performance analysis. One thing I feel is missing in SQL Server is a trail of various measures,&nbsp;for instance&nbsp;wait stats. I really wish Microsoft could include something in this area, which can be used as a baseline. I recently fount this, from the Tiger Team. It looks promising, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on June 8, 2017
  • re: Explaining Activity Monitor

    No, I can't comment on that. It happens that I open it, but only for a brief time period. I haven't traces any older version of SSMS so I don't know whether the SQL has changed. However, judging by the few wait types in the wait types table, I wouldn't be surprised of the SQL submitted by AM is pretty much the same since 2008 (which is when we got ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on February 18, 2017
  • Explaining Activity Monitor

    This post is not about how to use the Activity Monitor (AM) tool in SQL Server Management Studio (SSMS) there are loads of such posts written already. Also, it is not about dissing AM, you will find such posts as well. What I want to do is to explain the information in AM, for instance what time span the information covers. I see lots of ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on February 16, 2017
  • re: Adjust autogrow setting for your database files

    Sorry for the late reply, it seems email notifications for comments are missing at the moment. If you have instance file initialization, then a data file can grow immensely quicker than a log file. So, yes, we can have a bigger autogrow for data files. I didn't want to complicate my script with this, in the name of Keep It Simple... :-)
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on February 2, 2017
  • Adjust autogrow setting for your database files

    I very frequently see too small autogrow value for database files.&nbsp;Even the default in many cases. The defaults prior to&nbsp;SQL Server 2016&nbsp;are 1 MB for data files and 10% for log&nbsp;files, adjusted to a little bit better values in 2016. One of the tings I often do when I start working on a SQL Server is to adjust the values to ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on December 20, 2016
  • Keep more history for your Agent jobs

    SQL Server Agent is in my opinion way too restrictive when it removes old job history information. This information is store&nbsp;in the dbo.sysjobhistory&nbsp;table in the msdb database. Unfortunately, Agent will by default only keep 1000 rows in this table. I have on many occasions wanted to for instance check last execution of the weekly job. ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 16, 2016
  • Log Page Life Expectancy over time

    You often see Page Life Expectancy referred to as an interesting performance monitor counter. And it can be! It&nbsp;indicates for how long a page is expected to stay in cache, from the time it was brought into cache. But just looking at a snapshot value doesn't say that much. It might be high, but that is because you haven't had a high turnover ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on September 7, 2016
  • Update for Books Online with functioning index (2016)

    Good news, everybody! Microsoft recently released an update for the local Books Online, with a functioning index for the relational engine. Earlier versions were missing those index bits, but not for everyone (a theory is that it depends on what server you hit when you downloaded the BOL bits). Basic steps to get them (see my earlier blog, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on September 6, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement