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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2007-08-06 : 04:32:29
|
| I had a problem where some users were experiencing timeouts when trying to add a single record to a table with 2.3 million records.It's not a very wide table; only 10 columns and the biggest column in varchar 500. The rest are guid, datetime, tinyint...There is also an old VB app that inserts about 3000 records a day into this table during office hours while users occasionally try and insert a record into this table.Something said to me that the problem could be indexes but I wasn't quite sure because I though indexes only have an impact on select, delete & update. And not particulary on insert. But I checked it out anyway and noticed that the 3 indexes (1 column PK, 1 column Clustered & 1 column non-clustered) weren't padded. So I changed that (Fill Factor 95) and the problem has gone away. But why? I thought the insert would just have appended it to the end of the index before I made this change? Why would that time out? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2007-08-06 : 07:21:19
|
| I'm afraid that doesn't really answer my question - unless I'm missing something here... |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-06 : 12:28:03
|
| Sql will update index pages when insert rows in the table, check page split/sec in perfmon. |
|
|
|
|
|
|
Why did it work?