Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rowter
Yak Posting Veteran
76 Posts |
 Posted - 2011-10-25 : 18:25:53
|
| Hi All,We have a .Net based web application.Each client of ours has a different database.All these databases reside on the same server.Eventhough tables and views are same in each database, some have more transactions than others. Some of these databases are bigger than others.We are using Sql Server 2008.My questions:1)Can i control memory assigned for each database?I want to assign more memory to databases that have more transactions and less to ones that have less number of transactions.2)Is this a good approach?Thanks in Advance. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-10-25 : 19:17:37
|
| 1) No.What you can do, on SQL 2008, is use resource governor, but that controls workspace memory for queries, not the data and plan cache. SQL will manage the data and plan cache preferring tables and queries that are used more often, so things should work out kinda the way you want, providing you have enough memory.--Gail ShawSQL Server MVP |
 |
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-10-26 : 02:18:50
|
| You can control memory settings at an instance level. Install separate instance and move databases to those instance. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-10-26 : 08:40:36
|
quote:
Originally posted by rowter
Hi All,We have a .Net based web application.Each client of ours has a different database.All these databases reside on the same server.Eventhough tables and views are same in each database, some have more transactions than others. Some of these databases are bigger than others.We are using Sql Server 2008.My questions:1)Can i control memory assigned for each database?I want to assign more memory to databases that have more transactions and less to ones that have less number of transactions.2)Is this a good approach?Thanks in Advance.
It is not at all a good approach.Tell those clients who have huge databases and have more transactions to buy independent servers.What are you gonna do when your no of clients increase.Say now its 50 and by 6 months down the line say its 200.Please don't tell me that you will still be having the same server and have all those 200 databases on it.PBUH |
|
|
|
rowter
Yak Posting Veteran
76 Posts |
Posted - 2011-10-26 : 12:57:24
|
| Thanks for your replies. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
Managing Menory for each database in Sql Server