Sql Server Resource Management

Question

Sql Server Resource Management

Jiann

SSC Rookie

Points: 41
More actions
April 27, 2011 at 2:50 am

#236385

Have any white paper prove that database schema on SQL server 2008, will impacting the database resource management (Memory, I/O CPU) ?
Do any anyone know about this

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ali Tailor Hall of Fame Points: 3769 More actions · Answer 1

bjiann (4/27/2011)
Have any white paper prove that database schema on SQL server 2008, will impacting the database resource management (Memory, I/O CPU) ?
Do any anyone know about this

I'm also don't have this kind of proving paper but, I think RG is regards to Hardware (Memory, I/O CPU) not to Software so it will not effect the database.

Ali
MCTS SQL Server2k8

Jiann SSC Rookie Points: 41 More actions · Answer 2

How about different database? will SQL server 2008 manage the resource differently for different database on the server?

Btw, have any white paper discuss about how sql server manage the resource ?

Ali Tailor Hall of Fame Points: 3769 More actions · Answer 3

Hi

Visit the Following Liks may help you

http://msdn.microsoft.com/en-us/library/ee151608(v=sql.100).aspx

Down load White Paper from :

http://download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/ResourceGov.docx.

Ali
MCTS SQL Server2k8