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 |
|
abubin
Starting Member
3 Posts |
 Posted - 2009-04-22 : 00:36:40
|
| First, I am new to this forum and newbie to MSSQL. So please forgive me if this has been mentioned before.I have a MSSQL2008 with around 10 databases. The sizes of the databases range from 100MB to 2GB. Users will connect to this database from their webserver. The server is intel xeon 2.8 with 4GB ram, windows 2008 x64.Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 7.0.6001.18000Microsoft .NET Framework 2.0.50727.3053Operating System 6.0.6001Anyway, we keep on getting frequent problem where the database become sort of hang. Connection from client will fail. The only way we found to resolve this is to stop and start MSSQL service. Some users even need to restart their IIS website service for it to work again.We have tried looking into limiting the resources usage to max memory to 3GB but it still happens. AWE is turned off because we are already using x64.We suspect maybe some users did not optimize their database and the usage. So, they might be taking too much resources. We are wondering is there a way to limit resources used by each database. We want to try to limit some users that we suspect are using too much resources.Appreciate any feedback. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-22 : 00:39:35
|
If you are using the Enterprise Edition, you can utilize the Governor to control resources.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
abubin
Starting Member
3 Posts |
Posted - 2009-04-22 : 01:19:24
|
| It's Standard edition.edit:After googling around for resource governor, seems like Standard edition also have this function? Perhaps Enterprise have extra function in this governor feature? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
abubin
Starting Member
3 Posts |
Posted - 2009-04-22 : 03:21:59
|
| geez...no resource governor for standard edition. :(Any alternative method for standard edition? |
|
|
|
|
|
|
howto limit resources by DB level?