hi Sylvain,
[quoted text, click to view] Sylvain Aufrère wrote:
> Thank you Andrea,
>
> Ok, there is nothing to see open recordsets.
> But, which tools allows seeing the application activity on MSDE data
> base ? Which tables is opened? read? written? Who? When?
you can perhaps monitor active connections both via Enterprise Manager or by
executing sp_who filtering out for you required database...
actually read write operations depend on user's activity... if your user
form is simple waiting for user input you'll see no db activity at all...
tables are not opened... they are read and eventually written... they can
even bre read from cache as SQL Server try to keep them alive on cache once
read... writing conditions depends on database recovery model too, as dirty
pages can be flushed to the transaction log and stay there untill a backup
log or, with simple recovery model, be flushed to data pages at recurring
checkpoints...
[quoted text, click to view] > My goal is to know if my development team correctly releases the data
> base objects.
> I seek a "systematic" method to check that.
you can perhaps use the SQL Server Profiler running traces, and/or ad a
specific SQL Server counter on the System Monitor...
have a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_mon_perf_76cm.asp
for further info... and all counters are successively exploded..
but I do think the best check is code review...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://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
