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 36 (351 total posts) < 1 second(s)
  • re: SSMS 17.3 has Profiler built-in

    Verify the version of SSMS (Help, About). Also, perhaps you are connected to an old version of SQL server?
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 12, 2017
  • SSMS 17.3 has Profiler built-in

    We all know that Profiler and its background functionality SQL Trace has been deprecated since 2012. Right? And we have all switched to using Extended Events (XE), a long time ago, right? No, the reality is that many of us still uses the old tracing infrastructure. This can be for various reasons, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 10, 2017
  • Local Books Online, as of 2017 August

    This seems to be a never ending story, having a locally installed Books Online for SQL Server, that is. Some of you recall that I have posted about this before. This post is about my experiences for the current state of Books Online. Things has changed since I last blogged this. Among other things, MS has re-worked the documentation, including ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 15, 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
1 2 3 4 5 Next > ... Last »
Privacy Statement