Q
Problem solve Get help with specific problems with your technologies, process and projects.

Allocating percentages of memory to each database

I have several databases running on the same server, and sometimes I observe a great decrease of prestations on one of these databases while running queries on the others. I have about 40-50 clients who works simultaneously on the critical database running real-time queries through a software developed in Visual Basic. Is it possible to assure a certain percentage of memory (or other resources) to each database in order to avoid interferences between them? May this solve the problem?

It isn't possible to do that in a single SQL Server. All machine resources are shared amongst the databases. If you need dedicated processing to a specific database, then I'd suggest installing a second instance on that server and using processor affinity to allocate processing resources.

 

For More Information

This was last published in June 2003

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close