Is there any reason for this approach IF SSRS is installed? I'm thinking a simple query, report and subscription would be the way to go.

Thanks, this is helpful!

I started working today to add the collection and reporting of configuration data. I created a query that will report all changes within the...

I'm having this problem with IE8 & 9 and SSRS 2008 R2. Does anyone have the solution??

Thanks!!

Good post. While I don't have an immediate use for this, I'll tuck it away for the future.

Also, I do know why you felt the need to include a...

I wonder if Service Broker or a Data Driven Subscription would have been a better solution.

Thanks Mohammed! I must have read too fast. Both flags have to be enabled to see the zeroing in the log and data files. Then, the service...

I just created a test database on my Dev machine and I don't see anything in the log about zeroing the data file or log file. What am I...

The approach presented works well for a single client. I'm not sure how it would work in the current format if multiple clients needed to be shown. Something...

I've been pulling my hair out today with this error. I was especially frustrated when I was able to get my package to work using the same destination table...

-

Ok, I did some more research on this and it looks like the counter SQLServer:Locks/Lock Wait Time (ms) will not actually record until the locking event ends.

Here...

Thanks for the quick response!

I wonder though if this is always the best counter since it doesn't relate to the amount of time locks are being held. It...

I know this is an old post, but has this been resolved. I'm having the same problem!

Indicators

I really like the new indicators. I recently used them in a new financial report to quickly draw attention to troubled accounts. The thing I didn't like is...

Interesting...Can you show the IO stats?