Adjusting SQL embedded instances

Allocated memory issue: sqlservr.exe « Bart’s Weblog

Allocated memory issue: sqlservr.exe « Bart’s Weblog — Mon, 07 Jul 2008 06:56:03 GMT

Pingback from Allocated memory issue: sqlservr.exe « Bart’s Weblog

THE OFFICIAL BLOG OF THE SBS "DIVA" — Mon, 07 Jul 2008 04:29:04 GMT

John — Wed, 20 Feb 2008 05:40:09 GMT

Thanks for the tip. Most helpful!

francisco valiente — Sun, 03 Feb 2008 19:03:15 GMT

You save the day. Now how can i do it to 212 server in one shot.

Chris Knight — Thu, 27 Dec 2007 00:24:41 GMT

Dean - got an authoritative reference for this? Benchmarks?

Chris Knight — Thu, 27 Dec 2007 00:16:41 GMT

No need for tasklist if you're using Sysinternals' Process Explorer - hovering over the entry gets you the SQL instance information.

Also, if you don't want to download SQL Management Studio, you can follow the steps in MSKB <a href="support.microsoft.com/.../a>.

Dean — Wed, 26 Dec 2007 15:27:16 GMT

For SQL make sure you turn off Hyperthreading in the BIOS. Hyperthreading slows SQL down.