BLACKTOP: Writings From the Road

TIP: Reducing SQL Server 2005 Memory Usage

Ever notice after a hard day working away at the old data mine in a Virtual PC that SQL Server takes up a pretty good chunk of your available memory?  If you're like me, you could use this memory for something else.  Here's how you can limit how much memory SQL Server users:

  • Open SQL Server Management Studio
  • Connect to your server
  • Right-click on your database server name and choose Properties
  • Click Memory, set the maximum amount of memory, then click OK
  • Restart your SQL Server service

If you watch SQL Server in task manager, you'll find that it sometimes exceeds your maximum limit, but during idle times it will drop back down.

Published Friday, April 25, 2008 12:23 AM by DavidL

Comments

No Comments
Anonymous comments are disabled

About DavidL

I've been in IT over 15 years. Along the way, I've worked on mainframe applications (ugh) and UNIX (double ugh); I've done client server applications with VB and C++ and web applications with ASP. My favorite, though, is .NET. I've been working with .NET since beta 1 of 1.0 (I think they used punched cards back then) and I've always been pleased by the way it lets the developer focus on the business problem instead of housekeeping. For the last 7 years I have been a corporate developer in imaging and workflow with another company's product. After seeing what blackpearl can do, I am blown away by how quickly an application can come together. I'm looking forward to being part of something big!