Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

DotNine SQL Server and more

I am a database specialist from the Netherland with my main focus on Microsoft SQL Server. My IT career began 14 years ago as a System Administrator. I have been working with SQL Server for more then 10 years now and a full time DBA for 5 years.

Speaking at SQLSaturday #336 Holland

I received some great news this week, my session about wait statistics is selected for SQLSaturday #336 in Utrecht, Holland!

This will be my first SQLSaturday as a speaker and I am really looking forward to it!

There are more than 160 sessions submitted by great SQL Server experts around… Read more

0 comments, 110 reads

Posted in DotNine SQL Server and more on 23 August 2014

New website

As you can see the webpage has changed!

New features are:
- Syntax highlighting on code snippets (and easy copy/paste)
- Better readability
- Faster
- Less spam in comments

All articles can be viewed again. I tried to update all the internal links, if, however, you find a link… Read more

0 comments, 119 reads

Posted in DotNine SQL Server and more on 11 August 2014

Examining OLEDB waits

On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this article we will take a closer look at OLEDB waits to help you understand where they come from.

OLEDB

OLEDB or, Object Linking and Embedding DataBase, is a Microsoft… Read more

0 comments, 7 reads

Posted in DotNine SQL Server and more on 11 July 2014

Examining OLEDB waits

On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this article we will take a closer look at OLEDB waits to help you understand where they come from.

OLEDB

OLEDB or, Object Linking and Embedding DataBase, is a Microsoft…

Read more

0 comments, 141 reads

Posted in DotNine SQL Server and more on 11 July 2014

Finding the last successful CHECKDB

One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using CHECKDB. Not only does CHECKDB check the health of important internal pages of your database like PFS, GAM, IAM and many more, it also check for errors in your data…

Read more

0 comments, 882 reads

Posted in DotNine SQL Server and more on 26 June 2014

Finding the last successful CHECKDB

One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using CHECKDB. Not only does CHECKDB check the health of important internal pages of your database like PFS, GAM, IAM and many more, it also check for errors in your data… Read more

0 comments, 9 reads

Posted in DotNine SQL Server and more on 26 June 2014

Query backup history

As a quick script tip for today I’ll show you a script I use regularly for reporting purposes.
It shows you the backup history on your instance for successful backups ordered by the most recent first:

1
2
3
4
5
6
7
8
9
10
11
12
13
14…

Read more

0 comments, 7 reads

Posted in DotNine SQL Server and more on 13 June 2014

Query backup history

As a quick script tip for today I'll show you a script I use regularly for reporting purposes.
It shows you the backup history on your instance for successful backups ordered by the most recent first:

-- Get the latest successful backups
-- Shows databasename, backup start & end time,…

Read more

0 comments, 266 reads

Posted in DotNine SQL Server and more on 13 June 2014

Examining PAGEIOLATCH waits

In a previous article we looked at CXPACKET waits, a wait type that is can be on the top of your server’s list if you enabled parallelism using the MDOP setting.

Another wait type that you probably will be seeing in your top 10 of waits (unless you have… Read more

0 comments, 7 reads

Posted in DotNine SQL Server and more on 6 June 2014

Examining PAGEIOLATCH waits

In a previous article we looked at CXPACKET waits, a wait type that is can be on the top of your server’s list if you enabled parallelism using the MDOP setting.

Another wait type that you probably will be seeing in your top 10 of waits (unless you have…

Read more

0 comments, 214 reads

Posted in DotNine SQL Server and more on 6 June 2014

How SQL Server statistics are generated and updated

One of the easiest ways to increase query performance on your database is making sure your statistics are up-to-date. Statistics are – if you enabled the options in your database properties – automatically created and updated by the SQL Server Engine. This does not however mean that the statistics are… Read more

0 comments, 7 reads

Posted in DotNine SQL Server and more on 16 May 2014

How SQL Server statistics are generated and updated

One of the easiest ways to increase query performance on your database is making sure your statistics are up-to-date. Statistics are – if you enabled the options in your database properties – automatically created and updated by the SQL Server Engine. This does not however mean that the statistics are…

Read more

0 comments, 1,667 reads

Posted in DotNine SQL Server and more on 16 May 2014

Analyzing CXPACKET waits

One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.

This wait type is usually at the top of the list when you query the sys.dm_os_wait_stats on servers where you configured the MDOP setting to be anything but ‘1’. CXPACKET waits… Read more

0 comments, 7 reads

Posted in DotNine SQL Server and more on 4 April 2014

Analyzing CXPACKET waits

One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.

This wait type is usually at the top of the list when you query the sys.dm_os_wait_stats on servers where you configured the MDOP setting to be anything but ‘1’. CXPACKET waits…

Read more

0 comments, 1,964 reads

Posted in DotNine SQL Server and more on 4 April 2014

The power of the baseline

There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines!
While this is a blog about SQL Server, baseline monitoring isn’t something only DBA’s do. Actually everyone uses baselines in one way or the other. For instance, when you receive… Read more

0 comments, 10 reads

Posted in DotNine SQL Server and more on 21 March 2014

The power of the baseline

There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines!
While this is a blog about SQL Server, baseline monitoring isn’t something only DBA’s do. Actually everyone uses baselines in one way or the other. For instance, when you receive…

Read more

0 comments, 1,105 reads

Posted in DotNine SQL Server and more on 21 March 2014

How wait statistics are generated

In our last article “Why wait statistics are important and how you can start collecting them now!” we discussed a method of capturing wait statistics and a way to analyze them. Some background information on how wait statistics are generated by the SQLOS will certainly help you with… Read more

3 comments, 7 reads

Posted in DotNine SQL Server and more on 6 March 2014

How wait statistics are generated

How wait statistics are generated

In our last article “Why wait statistics are important and how you can start collecting them now!” we discussed a method of capturing wait statistics and a way to analyze them. Some background information on how wait statistics are generated by the SQLOS…

Read more

0 comments, 79 reads

Posted in DotNine SQL Server and more on 6 March 2014

Why wait statistics are important and how you can start collecting them now!

Why wait statistics are important and how you can start collecting them now!

Wait statistics have always been a very important tool in troubleshooting complex performance issues or monitoring the impact of changes on your SQL Server. I use wait statistics daily in helping clients troubleshoot performance issues they are…

Read more

0 comments, 109 reads

Posted in DotNine SQL Server and more on 28 February 2014

Restoring Filegroup backups on another server, and why it won’t work…

We have 2 different SQL Servers which both have a copy of the AdventureWorks2012 database in Full recovery mode.

One of the SQL Server hosts the primary copy of the AdventureWorks2012 database which gets restored every night to the other SQL Server as a secondary copy for development use.

One… Read more

0 comments, 7 reads

Posted in DotNine SQL Server and more on 20 February 2014

Older posts