SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


QueryStore practical everyday use


QueryStore practical everyday use

Author
Message
pti-704936
pti-704936
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 145
Hi

We have been using QueryStore since day 1 of our SQLServer 2016 installation

For every day usage though, the standard reports does not suffice to the diffent tasks/challenges that can occur, or it takes quite some time to find the culprit via the reports

Therefore we have build a number of stored procedures using the querystore tables.

In the process of building those i have not found many blogs/articles describing how to use Querystore, apart from the basic intro articles

To help others get past the same barrier i am thinking of writing an article showing what we have done:

QS_GetQueryID - returning the query_id(s) of specified object, very usefull when wanting to use the report 'tracked query'
Optional parameters gives the possibility to:
select timeperiod,
specific object

QS_GetExecutionError - returning name of object and failed execution count
Optional parameters gives the possibility to:
select timeperiod,
specific object

QS_ObjectExecutionStatistics - returning a dataset similar to the report 'Object Execution Statistics' runnable from SSMS, just using the querystore
Optional parameters gives the possibility to:
select timeperiod,
reporting level: verbose og summary,
specific object,
and more

QS_ChangedPerformance - Returning a dataset similar to the QueryStore report 'Regressed queries'
Optional parameters gives the possibility to:
select timeperiods to be used for the calculation (default is the same as the report, last hour against last week),
selecting progression or regression of the querys,
specify list of objects to investigate,
and more

Do you think it will be of interest ?

I have started the writing process, but i am a litle uncertain to how safe the procedures are supposed to be
I mean should i have every issue on giving wrong parameters covered or is it ok just to point out that 'it's a work in progress'


Regards

Peter Tilsted
Steve Jones
Steve Jones
SSC Guru
SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)

Group: Administrators
Points: 593878 Visits: 21006
This would be interesting. What Id' say is that you shoudl write about how you use this to help you, not try to solve every possible issue. You built these procs to solve a problem, so solve that problem and explain it.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
pti-704936
pti-704936
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 145
ok, i'll do that
Steve Jones
Steve Jones
SSC Guru
SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)

Group: Administrators
Points: 593878 Visits: 21006
bump

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
pti-704936
pti-704936
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 145
i just got bumped :-),
i haven't forgotten the article
i will be presenting the material in a local usergroup next month, and will be using there feedback when writing the article
regards
Peter
Steve Jones
Steve Jones
SSC Guru
SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)SSC Guru (593K reputation)

Group: Administrators
Points: 593878 Visits: 21006
Thanks

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search