SQLSERVR.EXE using total memory

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

Have you tried setting the memory configuration options?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

aksh.2411 Right there with Babe Points: 762 More actions · Answer 2

Hi,

No i have not yet set MAX memory.but it will work??

and according to you how much memory do i set for SQL & how much for OS?

Thanks,

Akshay

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Please refer to the following article.

Regards,

WC

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Much more advanced but usefull reading. Reffer to all releated links in the article..

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

I'm curious as to whether your problem been resolved or not?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/