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.

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, 116 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, 846 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:

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

Read more

0 comments, 234 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, 190 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, 1,589 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, 1,915 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, 1,082 reads

Posted in DotNine SQL Server and more on 21 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, 73 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, 88 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, 104 reads

Posted in DotNine SQL Server and more on 20 February 2014

SQL Server Quick Tip: Growing your database past 2TB on SQL Server 2008

A couple of days ago I had to manually grow the database data file for a client, they do not use autogrowth and plan growth events. They are running on a SQL Server 2008R2.
The database data file was 1,9TB before the growth event, since we always increase the data…

Read more

0 comments, 64 reads

Posted in DotNine SQL Server and more on 14 January 2014

A Tour of the Transaction Log: Part 3 Reading Log Backups

In part one and two of our Tour of the Transaction Log articles we focused on reading events from the active transaction log, there can be times when that will not be enough and we actually have to dig deeper into transaction log backups to find the information we need.

Read more

0 comments, 74 reads

Posted in DotNine SQL Server and more on 15 November 2013

A tour of the transaction log : Part 2 DELETE operations

In the last Tour of the Transaction Log we looked at how INSERT operations behave in the transaction log.
In this part we will be looking at DELETE statements and how we can find out who deleted that record in your table!

Again, commands in this article are undocumented by…

Read more

0 comments, 53 reads

Posted in DotNine SQL Server and more on 4 November 2013

A tour of the transaction log: Part 1 INSERT operations

The transaction log is a very important part of SQL Server. Every data modification operation is logged in the transaction log before being ‘hardened’ to the database file.

There are plenty of scenarios where you might take a look at the transaction log like point-in-time transaction log backup restores (to…

Read more

0 comments, 57 reads

Posted in DotNine SQL Server and more on 7 September 2013

Optimizing SQL Server Backup and Restore

When your databases grow, operations, like a database backup and restore, are going to take a longer time to complete. Maybe at some point you are running out of your time window to complete a database backup or a restore. Instead of expending your time window (if that is even…

Read more

0 comments, 81 reads

Posted in DotNine SQL Server and more on 21 August 2013

How implicit data type conversion slows down your query

Implicit data type conversion is one of those things you hardly think about or notice when writing your queries. But as you will soon find out while reading this article it is one of those small tweaks that can increase the performance of your query!

Implicit data type conversion happens…

Read more

0 comments, 62 reads

Posted in DotNine SQL Server and more on 8 August 2013