September 4, 2014 at 1:10 pm
I cannot find the Page Splits/sec counter in Profiler. It is under Access Methods, right? Well, I cannot find that either!
This is on Sql Server 2012 SP2 and I am opening a new trace in Profiler and then I click on Show All Events, but I do not see anything that leads me to the above.
Can someone point me to the above?
By the way, I want to monitor this during an update to a new column. The column has nulls allowed and when I update the column, it is taking up a bunch of new space. My theory is that the pages are pretty full and we are getting a bunch of page split from the update.
September 4, 2014 at 1:18 pm
nevermind. I found it in Perf Mon.
September 5, 2014 at 3:44 am
Yep, that's a Performance Monitor counter.
Side note, since you're in SQL Server 2012, I strongly suggest you toss Profiler and go with Extended Events. They're much more light weight, there are more events to capture, pretty much better in every way than trace.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 5, 2014 at 4:01 am
Just bear in mind that the counter in question is not the number of mid-index page splits (which are the expensive ones that cause fragmentation)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply