hi,
i have an instance of MSDE that seems to be chomping away at all available resources. wound up installing SQL server mgmt tools on the machine hosting the instance & upon inspecting the management logs, this error pops up about 1ce every 3 minutes:
This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
the instance was installed as the backend for a print tracking application that communicates with about 120 clients on the floor. is it possible that this application is trying to hold too many concurrent connections? wouldn't the MSDE instance stave off client requests until others were finished? at that (and to the best of my knowledge), client requests or reports out to the client consist of *minimal* data -- we're talking tops of 3 rows with only a few scaler type fields.
anyway, is there any way to determine what process is tying this up? rather new to the management end of things here. any help is appreciated, thanks!
..:: mirirom ::..
i have an instance of MSDE that seems to be chomping away at all available resources. wound up installing SQL server mgmt tools on the machine hosting the instance & upon inspecting the management logs, this error pops up about 1ce every 3 minutes:
This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
the instance was installed as the backend for a print tracking application that communicates with about 120 clients on the floor. is it possible that this application is trying to hold too many concurrent connections? wouldn't the MSDE instance stave off client requests until others were finished? at that (and to the best of my knowledge), client requests or reports out to the client consist of *minimal* data -- we're talking tops of 3 rows with only a few scaler type fields.
anyway, is there any way to determine what process is tying this up? rather new to the management end of things here. any help is appreciated, thanks!
..:: mirirom ::..