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 |
|
sixside
Starting Member
12 Posts |
 Posted - 2007-09-11 : 12:02:06
|
| I've got a [Message] table that gets referenced a LOT in my application for inserts and reads (no edits or deletes) and I've tried everything that I can think of to speed up the performance, but it's still not as fast as I'd like it to be and I'm not sure where to turn to next. I've got a lot of simultaneous users all doing lookups and inserts into this one table with over 1 million rows. What should be next steps be for actually tracking down the bottle neck to figure out how to resolve the issue and increase performance for my users? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-11 : 15:52:23
|
We have a Logging table that gets around 8 million inserts a day, and each of those is updated once after the insert.We have to use the WITH (NOLOCK) hint in order to get any sort of reasonable performance querying the data. But the querying is non critical - i.e. we don't care about repeatability of the queries etc - so please give some thought o the implicates of NOLOCK before just chucking it in the code  The other problem that I perceive we have is that Statistics on the table are out of date almost as soon a s they are created, and I think this is preventing SQL Server making good use of the indexes on that table, so we sometime have to Hint to force the best Indexes to be used.Kristen |
 |
|
|
|
|
|
S L O W. One table getting hit a lot. What to do?