Grant Fritchey (8/23/2011)

---

Roy Ernest (8/23/2011)

---

I have this image of Gail in my mind where she gives dead pan response and makes you wonder if she is Kidding or being serious....

I have this image of Gail in my mind where she gives dead pan response and makes you wonder if she is Kidding or being serious. Grant I have already...

Authors know only to speak. They have no practical experience... 😀

just kidding... I have to sit a whole day at Seattle for a pre-con with these two. So I...

You do not see anything on the SQL Server error log?

Is there any dead lock or something happening on the Distributor? It can cause the distribution agent to shut itself down.

You said that you have HP server now. How many NICS does it have? How is it configured? Teaming or do you have a dedicated NIC for just File copy...

If you cannot change those ad hocs into stored procs, the other option is to set "optimize for ad hoc workloads". It is always better to make it as SPs....

7K. That is a small number.. 😀

Here is the Code.

WITH autostats ( object_id, stats_id, name, column_id )

AS ( SELECT sys.stats.object_id ,

...

I do not have a demo script to reproduce the performance problems. But I have the script that Kendal gave me to find the overlapping stats. If you want that,...

Yes, the existence of the stats for that column interferes with the selection of the index by the optimizer. I was banging my head with this issue one year back....

There is one problem with Autocreated statistics. It is rare but can happen and has happened in our environment.

Let us say we have a table with 6 columns with one...

Do you have lots of Ad-hoc queries running? It could put pressure on the cache since Ad-Hoc queries plan are not reused much unless you optimize for Ad hoc queries.

Try to download Adam Machanics sp_whoisactive . That might help you the most. But if you see it in the error log after a long time, the only way you...

Unless you have some kind of Audit running, you probably wont see any from the past. The only place you might find if anyone logged on to the DB is...