SQLPS Meets the DMV's

Question

SQLPS Meets the DMV's

SQLShark

SSCrazy

Points: 2204
More actions
January 8, 2016 at 10:00 am

#323461

Comments posted to this topic are about the item SQLPS Meets the DMV's

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

Nice contribution, but a little too brief of an article for me ; i'd hope to see something like what the purpose of the script is and how it would help me, instead of having to dig through code and comments to see what it's doing.

maybe a brief explanation of the results would be helpful too.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SQLShark SSCrazy Points: 2204 More actions · Answer 2

I will do another post with more of this type of code and be more specific with the next post. I took 1 line from a large powershell script I use to perform a remote capture of performance metrics. I intended to show the methods I use and also have not posted in many years up here. Currently I pull about 32 .csv files with 1 capture for review of the metrics with my current tool I use in production. I grab performance monitor data, query data, database file IO data. Thanks for the comments this will have me improve my next post, Ed.

SQLShark SSCrazy Points: 2204 More actions · Answer 3

The current posting grabs the performance monitor Memory Manager object and all it's underlying counters you would see if you cracked open perfmon and viewed this counter. 2 specific fields I look at are the pending and outstanding memory grants.

Ed