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 |
|
rb1373
Yak Posting Veteran
93 Posts |
 Posted - 2005-10-18 : 13:53:48
|
| Is there anyway to determine which tables are experiencing page splits? I have alerts sent to me for page splits, but I want to know which tables are experiencing page splits. Profiler doesn't seem to be have an event for this.Thanks,RaySS2K |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-10-18 : 14:00:17
|
| Use DBCC SHOWCONTIG command to check the fragmentaion level in table. The scan density and logical fragmentation will explain the amount of page split in table.RegardsSachin Samuel |
 |
|
|
|
|
|
determining source of page splits