question

nick2012 avatar image
nick2012 asked

Server moves help

Hi All, I am working on a licensing project, where in i have to find servers CPU and memory and move them to a new host depending on size to save cost. I a not sure how to go about this, Could anyone help?
sql server 2008 r2server
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·
What version of SQL Server are you using? There are a number of ways to obtain this information.
0 Likes 0 ·
nick2012 avatar image nick2012 commented ·
We are using 2008r2.
0 Likes 0 ·
KenJ avatar image KenJ commented ·
The CPU and memory for your virtual machines should be easily obtained for all machines at the same time using the virtualization product's management suite (vCenter for VMware, for example).
0 Likes 0 ·

1 Answer

·
JohnM avatar image
JohnM answered
I would start to look at the DMV sys.dm_os_sys_info. Reference: https://msdn.microsoft.com/en-us/library/ms175048.aspx There are also numerous ways to do this via scripting language, such as Powershell. https://technet.microsoft.com/en-us/library/dd315240.aspx Hope that helps!
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.