sql server misc:
I run several web applications servers ( Weblogic ) on Windows 2000.
These access databases on several SQL 2000/W2K servers.

Occasionally, my application servers will shut down because the database
server closes connections. On restart the service will have trouble
reacquiring connections.

The thing is, the database server, when this happens, does not seem
heavily loaded. It is often running at 3 to 5 percent capacity.

The error message in my application server log is "database cannot
accept new transactions".

Can you suggest where the restiction might be that prevents new
connections from being established with SQL server?


--
The Texeme Construct
updated 1/4 http://john-bailo.blogspot.com
updated often http://you-read-it-here-first.com

In article <z6mdnWs4V7DNDwPYnZ2dnUVZ_uzinZ2d@speakeasy.net>,
jabailo@texeme.com says...
[quoted text, click to view]

Do you have CPU licenses or individual CALS?

It sounds like you've either got a CAL problem or you're deadlocked.

--

spam999free@rrohio.com

[quoted text, click to view]

I believe it's just CPU licenses (how can I tell?)

[quoted text, click to view]

What number of CALs would the problem appear at?


[quoted text, click to view]

Yeah, this server is under heavy load!


--
The Texeme Construct
updated 1/4 http://john-bailo.blogspot.com
updated often http://you-read-it-here-first.com

In article <Rf2dnb0i1dx77T_YnZ2dnUVZ_rXinZ2d@speakeasy.net>,
jabailo@texeme.com says...
[quoted text, click to view]

you would know because you have to buy them - either setup as CPU
license or you bought X number of SQL cals.

[quoted text, click to view]

No telling, but, if you have more connections than CAL's, provided you
in CAL mode and not CPU mode, it would be at that number.

[quoted text, click to view]

Have you looked at the blocks and such?

--

spam999free@rrohio.com