Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-10-29 : 08:26:06
|
| Ashwani writes "Hi there,I'he a db of about 1.2 GB size on Windows 2000. Both Windows and SQL have latest patches on them. I wonder about the performance of my db. On running SQL profiler and checking 'Objects:Auto Stats' event, I get 'created:col1,col2' returned about 40 - 50 times every min. Initially I thought that my db requires an index on these columns but on further research I found that these cols exist in many tables and are mostly indexed. Another problem is I couldn't find which table or column sql is creating statistics for. Please help." |
|
|
|
|
|
Lots of auto stats 'created' events in SQL Profiler.