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 |
|
Kristen
Test
22859 Posts |
 Posted - 2005-11-30 : 14:19:43
|
We monitor Page Splits each minute:SELECT cntr_valueFROM master.dbo.sysperfinfoWHERE object_name = 'SQLServer:Access Methods' AND counter_name = 'Page Splits/sec' AND instance_name = '' Yesterday the differential, minute-to-minute, was between 100 and 250, but for two adjacent minutes within that period it hit 5,421 and 7,288. Our previous recent "high" has been around 900, and no other really high figures recently. What might cause this? (No known scheduled jobs running, nothing special happening that I can think of)Kristen |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-30 : 16:20:46
|
To stab myself with? or split the pages with?  Kristen |
 |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2005-11-30 : 16:34:10
|
| I might be missing something, but my guess is that the Page/Splits are caused when indexes end up having data inserted into them (or get updated) which causes splits. The splits are because a value got inserted which overflowed a filled page, and the last value in the paqe got split to a new page. Is it possible that someone did a bulk insert during that time period? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-30 : 16:36:46
|
| "Is it possible that someone did a bulk insert during that time period?"We run data imports from "another system" every 15 minutes, or so. There is a log of how many rows get imported, which I will check. Completely forgotten about that possibility, thanks for the pointer!Kristen |
|
|
|
|
|
|
|
|
What is [causing] Page Splits?