April 27, 2005 at 3:37 pm
Hi everyone,
It seems some object(s) in my db are constantly doing split pages. The performance counter SQL Server: Access Methods > Page Splits/Sec is always between 0 and 3. It never stays at 0 for more than a few seconds. How can I find the object(s) that are responsible for the split paging? Thanks in advance for your help.
April 27, 2005 at 6:57 pm
Page split could be normal in your situation depending on how busy your system is.
I would suggest you to run DBCC SHOWCONTIG to tables to find out fragmentation information for the data and indexes of them and go from there.
Do you see any I/O related issues?
April 28, 2005 at 11:39 am
Hi Allen, thank you for your help on this.
I see a lot of PAGEIO_LATCH waittypes on this server in particular. Yesterday I saw the page split counter go in the 20s and stay there for a while. I wish SQL had an easier way to deal with such issues. I am defraging the indexes, but I am afraid that there is not much I can do about the tables.
April 28, 2005 at 11:46 am
PAGEIOLATCH is used for disk-to-memory transfers and a significant waittime for these waittype suggests disk I/O subsystem issues.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply