You and your family are in our thoughts, Ken!  Looking forward to hearing from you again.

Hi James-

What permissions do you have on the server? You need ALTER ANY EVENT SESSION in order to create and view sessions. And what specific build of SQL...

Correct, the script does only work for SQL Server 2012 and higher, and this is noted in the post. If you're using SQL Server 2008R2 and below, stick with...

Jared, you're correct! Listing 9 should have the following code:

/* Extended Events */

CREATE EVENT SESSION [XE_ReadsFilter_Trace]

ON SERVER

I have notified SSC and we'll get it updated, thanks for letting me...

Hi-

The script to capture the information is in the post. What are you having a problem with?

Erin

Glad it was helpful!

-Erin

You're right! It should be:

; INSERT [BaselineData].[dbo].[FileInfo] (

I will see if I can get the script updated, thanks for the catch!

Trust your instincts, but always test in a TEST/DEV environment first 🙂 Then you prove how much you *do* know, and you prove it out in a safe environment.

Erin

HildaJ...

Hi-

You can store baselines from different servers in one database - you can really do anything you want 🙂

You'll have to design a strategy and figure out how...

Hi Bill-

You can absolutely script baseline capture in SQL 2000 - but you're going to have to modify the scripts provided (or create new ones) and you might not be...

Transaction log backup sizes should be about the same size whether you're in FULL or BULK LOGGED recovery...

http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-2830-bulk_logged-recovery-model/

_Beetlejuice (2/4/2013)

---

Hi Erin

Nice article. I have a question relating to clearing the wait statistics on an instance. On my production Servers, I capture the wait statistics every hour, as soon...

If you're running SQL Server 2008R2 SP2, or SQL Server 2012 SP1, you can use the new statistics DMF sys.dm_db_stats_properties. I have a query for it on my blog:...

Thanks for the comment! You can find all the baselines articles here: http://www.sqlservercentral.com/articles/baselines

Enjoy 🙂

Erin