SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Query store is to store queries; not key performance counter like PLE.
Capturing PLE with Query Store
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 68%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mark Gordon
926
Reputation points
Fellow DBA's 1 - Is there any way to setup or extract PLE from Query Store?
thx MG
SQL Server | Other
-
LiHongMSFT-4306 31,621 Reputation points2024-02-28T02:54:10.51+00:00 Hi @Mark Gordon Do you have further question on this issue, could we offer more support?
If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)
Sign in to comment
Answer accepted by question author
Olaf Helper
47,621
Reputation points
-
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator2024-02-27T22:32:12.09+00:00 As Olaf says, no. For one thing, Query Store is on database level, and PLE is a server-wide value.
-
Mark Gordon 926 Reputation points
2024-02-28T12:47:19.49+00:00 thx Olaf. I did not think so but needed to validate with someone.
Sign in to comment