Steve,

I am planning to capture DDL_DATABASE_LEVEL_EVENTS and DDL_SERVER_LEVEL_EVENTS. I understand that those are much less frequent events than ones captured by DML triggers, but I am still concerned because out...

Yes, I did.

Thanks!

ALZDBA,

Could you please elaborate on how you save and analyze cache? Do you save contents of master..syscacheobjects or corresponding DMV? What kind of analysis do you perform?

Thanks,

Igor

First of all, thanks to everybody for feedback! I have inherited the database and unfortunately limited in what I can do to speed up performance. I agree that rewriting process...

I don't think there is significant amount of data added. I will try to run the view through DTA.

Thanks!

Thanks all of you for advice!

Igor

Thanks a lot , Jack!

Thanks a lot, Andrew!

Only Microsoft OLE DB Provider for SQL Server

Linked servers - yes, OLE Automation - no.

mikefle (2/2/2009)

---

Hi Igor,

We need to see when the problem appeared and more background, is it a misconfiguration, or a result of bad code being sent to the server, this could...

You are right, Michael! I executed DBCC CHECKDB and see numbers going up.

Thanks,

Igor

Hello!

Thanks for your replies! I did figure out that because of my retention policy (72) in distribution database, old transactions haven't been deleted immediately. I see that space...