Thursday, February 9, 2012

# of CPU for SQL Server

I have a question about sizing of a SQL 2000 server.
If my no. of transaction I need to update does not changes, when the data growth, do I need to add more CPU or memory to the SQL 2000 Server
Hi,
No need to increase the RAM or CPU directly. You measure the usage of MEMORY
and CPU for some time during peak usage situation
using Windows performance monitor or system Monitor.
If you find that CPU usage is always higher than 70% and memry usage is
higher than 80%, then add additional hardware resources.
Thanks
Hari
MCDBA
"Kelvin" <anonymous@.discussions.microsoft.com> wrote in message
news:28DD3CCE-93F0-46BA-AC99-FE60285A2275@.microsoft.com...
> I have a question about sizing of a SQL 2000 server.
> If my no. of transaction I need to update does not changes, when the data
growth, do I need to add more CPU or memory to the SQL 2000 Server
|||If it is possible that although the number of transactions does not change,
but the number of rows affected by the transactions changes or the amount of
data that people need to see increases over time, then you may need to
increase memory and processor as data volumes increase...
Index maintenance will also take more resources( as will the DBCCs)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kelvin" <anonymous@.discussions.microsoft.com> wrote in message
news:28DD3CCE-93F0-46BA-AC99-FE60285A2275@.microsoft.com...
> I have a question about sizing of a SQL 2000 server.
> If my no. of transaction I need to update does not changes, when the data
growth, do I need to add more CPU or memory to the SQL 2000 Server

No comments:

Post a Comment