Governor issue

Hi there,
If I have an application that loads 5 grids at the same
time, does this means that it uses 5 connections?
After the grid is loaded, can I assume that the 5
connections are released and that the governor count goes
back to 0?
Thanks,
FP
hi FP,
FP wrote:
> Hi there,
> If I have an application that loads 5 grids at the same
> time, does this means that it uses 5 connections?
usually you use 1 connection for more operations, that's to say the very
same connection can serve your 5 "SELECT..." commands... so you only have 1
active connection with 5 non concurrent workloads... (the workloads number
is important and not the connection number)..

> After the grid is loaded, can I assume that the 5
> connections are released and that the governor count goes
> back to 0?
as reported, when each workload is executed it will decrement it's count,
and assuming you have 5 successive workloads, the batches count always is to
1-0 -1-0 -1-0 -1-0 -1-0... even if Ado.Net opens 2 connections, assuming no
other batches are executing...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql