How do you use cloud databases? Take the survey.

Extracting data for rightsizing exercise

Hi, 

We are in the planning stage of moving our existings SQL Server VM's to AWS - simply using a lift and shift model.

We'd like to rightsize our environment beforehand to ensure we don't over-provision cpu's.

I would have hoped that Redgate would have some reports to assist with this but there doesnt appear to be any.  I also dont want to manually look at all the graphs.. 

How do we get access to the raw CPU data that Redgate is storing?

Ideally I'd like to be able to run queries against it to understand when various servers are going over x% of cpu for different timeperiods (eg 5, 10, 15 minutes).

Any advice? 

thanks. 
Tagged:

Answers

  • Alex BAlex B Posts: 1,131 Diamond 4
    Hi @Craig999,

    Though we don't support directly querying the repository we can't stop you from going ahead and doing so.  These may help (disclaimer: offered as is and it can change without notice with any new version):
    SELECT * FROM data.Cluster_Machine_PhysicalProcessors_StableSamples_View
    SELECT * FROM data.Cluster_Machine_Processors_UnstableSamples_View

    I have also discussed with the product manager and they will consider what you are looking for in the upcoming road map work on improving our cloud offering, specifically:

    Cloud cost information

    Surfacing cost information to help with cloud decisions.


    I hope that helps!

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.