Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

concurrent queries Expand / Collapse
Author
Message
Posted Sunday, October 28, 2007 1:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 29, 2007 12:22 AM
Points: 1, Visits: 31
I have this problem sql server has been optimized for 8 concurrent queries .this limit has been exceeded by 1 and performance may be adversely affected.
and realy the server performance is going to be deacrease when this message appearshow can I fix this problem without installing the new version of sql server ,
Would you please help me in this issue,

I use sql server 2000 , MSDE

Best Regards
Post #415770
Posted Sunday, October 28, 2007 12:23 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 1,388, Visits: 6,262
is a hard limit in msde 2000
http://www.petefreitag.com/item/194.cfm

sql server 2005 express doesn't has that limitation
http://databases.aspfaq.com/database/what-are-the-limitations-of-msde.html
Post #415795
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse