March 30, 2017 at 4:45 am
Hi All,
My question in short is does index rebuild or update statistics affect PLE, because i have a job collecting performance metrics and i noticed that PLE dropped from 1400 to just 9 during index rebuild job.
Not sure if it's related or just a coincidence.
Waiting for you feedback please.
Regards
Nader
March 30, 2017 at 5:07 am
It relates. Rebuilding index and updating statistics could bring lots of pages into the memory (depending on index and table size and in case of statistics update the size of the sampling).
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 30, 2017 at 5:11 am
Adi Cohn-120898 - Thursday, March 30, 2017 5:07 AMIt relates. Rebuilding index and updating statistics could bring lots of pages into the memory (depending on index and table size and in case of statistics update the size of the sampling).Adi
For update statistics job i am using FULLSCAN, so i guess that's why.
Thank you for your reply.
March 30, 2017 at 9:08 am
UPDATE STATISTICS all alone isn't going to affect your PLE. It's the changes that may result to execution plans when they have different (hopefully more accurate) row estimates that can affect PLE.
By the way, PLE is really only a nominal measure of load. It's a crappy measure of performance. I wouldn't be too focused on it.
"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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply