THE SQL Server Blog Spot on the Web

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


You searched for the word(s):
Showing page 1 of 38 (376 total posts) < 1 second(s)
  • 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
  • Poll, do you have an index for your local SQL 2016 BOL?

    This is for those of you who has installed the SQL Server 2016 documentation locally. If you haven't and want to do that, then read this:&nbsp; My question is whether you have an index for the relational database topics? For instance, using the ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 12, 2016
  • re: Books Online for SQL Server 2016

    Yes, Andreas, the old &quot;F1 and it just worked&quot;-times. I also discovered that the index isn't there - will add to the blog post now...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 7, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement