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

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