Prev: Date and time in a backup file name
Next: MICROSOFT SQL-DMO ERROR 5172
From: thomas on 6 Jul 2010 03:34
Dear Experts,

Could SQL server allocate resource evenly for each incoming query?
Because sometimes when one user perform a long running query (eg. over one
hour) , it seems other query were suspended and make its related application
timeout/waiting....

Can SQL Server 2008 tune on this ?

Thanks.


From: Erland Sommarskog on 6 Jul 2010 05:07
thomas (thomas(a)mail.com) writes:
> Could SQL server allocate resource evenly for each incoming query?
> Because sometimes when one user perform a long running query (eg. over
> one hour) , it seems other query were suspended and make its related
> application timeout/waiting....
>
> Can SQL Server 2008 tune on this ?

You could use the Resource Governor for this. However, this feature is
only available in Enterprise Edition.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Date and time in a backup file name
Next: MICROSOFT SQL-DMO ERROR 5172