SQL Personal Edition and limited queries running concurrentyl

• mipo

  Ten Centuries

  Points: 1346

  More actions

  June 22, 2005 at 7:13 am

  #102605

  We are running Personal Edition of SQL 2000 on a Windows 2000 Operating System.

  or Windows XP Proffessional.

  Sometimes we get the message:

  'This SQL Server has been optimized for 8 concurrent

  queries. This limit has been exceeded by 2 queries and

  performance may be adversely affected.

  I understood that the Personal Edition degrades performance if the maximum of 5

  Transact-SQL batches that are executed concurrently is exceeded.

  How can we find out which queries running concurrently cause this message?

  Running the SQL Profiler?

  Any other possibilities to trace this problem (except moving to SQL Standard version)?

   

  Thanks

  Mipo

• June 27, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Hans Lindgren

  SSChampion

  Points: 10496

  More actions

  June 29, 2005 at 3:38 am

  #569247

  Well, hmm. You could run Profiler at all times. But I guess it also counts as running query.

  Or you can do a script that executes sp_who/sp_who2 and automatically runs DBCC INPUTBUFFER on the SPIDs greater then 50...