Extracting data for rightsizing exercise
Craig999
Posts: 1 New member
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.
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
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):
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
Have you visited our Help Center?