var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
"This SQL Server has been optimized for 8 concurrent queries."
Does anyone know encounter this error before in SQL Server?
May I know what are the impact of this error and counter measures can be done to prevent this??
Which version is it?
Personal edition and msde are governed to slow down with 4 batches.
Try DBCC CONCURRENCYVIOLATION
It is MS SQL Server 2000 standard edition and is installed in Win2k server.
Does the server version has a limit also??
Resutls are as follows
Concurrency Violations since 2003-10-08 09:19:10.467
1 2 3 4 5 6 7 8 9 10-100 >100
99999 99999 99999 15214 906 228 642 49 283 2353 2353
I think i've found the problem
MSDE is installed.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors