Just out of curiosity, since you using SQL Server 2008, why did you not look for the tools provided be them? CT, CDC and SQL Audit? They have build in...

From the audit file? As per BOL, you just need to select from a function.

SELECT * FROM sys.fn_get_audit_file ('\\serverName\Audit\HIPPA_AUDIT.sqlaudit',default,default);

GO

Did you check the blog I posted?

Thanks Steve. You are THE MAN... 🙂 I will pay it on Monday when we meet at Lowells. 🙂

I am in. So is one of my first timer assigned to me. Unfortunately we cant have paypal account from our island. 🙁 Steve , Steve..... Help...!!!

From what you have stated, I can only guess that you have high IO bottlenecks. When the query is running slowly, is there any other activity going on on the...

I agree with SQLGuru. You need to identify which of your stored procs that references the table is eating up your CPU. Check your Wait types. You most probably see...

Here is another case with the same Domain having the same problem. This is bad news. As per blog by MSDN, any error state higher than 18 might require help...

Error State 38 is pretty rare. This could be because of some internal error. If you look at this blog from MSDN, you will read that you might require help...

READ UNCOMMITTED is not going to help in this. This is most probably because you are getting different execution plan at different times. There are lots of reasons why this...

This is a nice way to SPAM. 🙂 Very creative with links. 🙂

Both have the same hardware? That includes IO path, Memory, CPU etc.

Also did you take into account caching of data? Lots of reason why a query can take different...

Thanks Jeff. That was my second article for SSC. 🙂

This is the first time I have seen where an old thread (more than 3 yrs) get some interest. 🙂

Check this article out[/url]. The second part of it shows...

As far as I know, you could do an estimate by using sys.dm_os_performance_counters. use counter_name = 'transactions/sec' as your where clause along with instance_name. Please keep in mind that transactions...