Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS SQL Server RAM and Processor usage

Status
Not open for further replies.

MandyDroid

Programmer
Aug 25, 2009
350
US
Are there any controls in the MS SQL Server 2005 that can control processor and memory usage. I run some large reports but the system is only using 25% of my processesors and just over 500M RAM.

Avaya, Panasonic, Polycom, APC, MCP, A+
##################################
"When I was a child, I spoke like a child, I thought like a child, I reasoned like a child.
When I became a man, I gave up childish ways.
 
You can control the amount of RAM that the SQL Server will use via the sp_configure system stored procedure.

The SQL Server will use as much CPU power as it needs to in order to complete the tasks which are running against it.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top