May 5, 2011 at 1:04 pm
Hi,
We're potentially migrating a dev SQL server to another windows server. I'd like to be able to estimate resource usage to make sure the target server is capable of picking up the workload.
Aside from database size, I'd like to be able to capture memory usage. I understand that SQL server dynamically allocates necessary memory but is there a way to monitor the system to find an average? Is there a specific counter for SQL server 2005 to capture total memory usage? Also, our source physical server is hosting 2 separate SQL server instances. What's the best way to distinguish between the two?
Thanks!
May 6, 2011 at 1:37 am
My suggestion is to capture load during peak hours rather than average.
You can use PERFMON to capture required details.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2011 at 6:15 am
free_mascot (5/6/2011)
My suggestion is to capture load during peak hours rather than average.You can use PERFMON to capture required details.
HTH
hth, you're right about peak hours. Basing judgements off an average is going to lead to trouble. I should have elaborated more. Is there a specific counter that will show total memory use by sql server?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply