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
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 149
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 (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)

Group: Administrators
Points: 621440 Visits: 21265
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
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 149
ok, i'll do that
Steve Jones
Steve Jones
SSC Guru
SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)

Group: Administrators
Points: 621440 Visits: 21265
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
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 149
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 (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)SSC Guru (621K reputation)

Group: Administrators
Points: 621440 Visits: 21265
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
Carlos Robles
Carlos Robles
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 627
Hi Steve,
I have done a few presentations about Query Store during this year and also started to write a series or articles here at SCC but because of the time I have not had the chance to complete the writing but I will have some free time now at the end of the year.

Do you think this is still an interesting topic to write about? If you agree with that, I will do my best to complete the articles during this last two weeks of the year.
Thanks!

Carlos Robles
Data platform MVP | MCSA & MCSE, MCP, MCTS certified | ITIL v3 certified
Email: dbamastery@gmail.com
Twitter: @dbamastery
http://dbamastery.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