Article View: alt.pl.comp.lang.csharp
Article #1035Re: Procent wykonanej procedury
From: Michal Wojas
Date: Sun, 02 May 2004 12:37
Date: Sun, 02 May 2004 12:37
27 lines
1578 bytes
1578 bytes
> W jaki sposob robi sie w programach procent wykonanej procedury na > serwerze SQL?! > > Tak jak ma to miejsce np: w Enterprise Manager lub darmowym dbMgr2k. No wiesz Enterprise Manager ... wykonuje to zupelnie na innym poziomie ... dblib/obiekty DMO ... Niestety nie ma jakies uniwersalnej metody. Proponuje zastosowanie procedury ustawiajacy counter np.: CREATE PROC Test AS EXEC sp_user_counter1 1 WAITFOR DELAY '00:00:5' EXEC sp_user_counter1 2 WAITFOR DELAY '00:00:3' EXEC sp_user_counter1 3 WAITFOR DELAY '00:00:2' nastepnie dane odczytujesz z widoku ... select * from master..sysperfinfo. Lub poprzez performance manager. MW
Technical Details
Message-ID:
<c72prf$iu7$1@news.onet.pl>Path:
mbox-mo1.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!nntp.idg.pl!newsfeed.gazeta.pl!news.onet.pl!not-for-mailReferences:
<c6t71g$n9f$1@news.onet.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!nntp.idg.pl!newsfeed.gazeta.pl!news.onet.pl!not-for-mail From: "Michal Wojas" <mwojas...@onet.pl> Newsgroups: alt.pl.comp.lang.csharp Subject: Re: Procent wykonanej procedury Date: Sun, 2 May 2004 14:37:25 +0200 Organization: news.onet.pl Lines: 29 Sender: nowickam@poczta.onet.pl@michal40.net.autocom.pl Message-ID: <c72prf$iu7$1@news.onet.pl> References: <c6t71g$n9f$1@news.onet.pl> NNTP-Posting-Host: michal40.net.autocom.pl X-Trace: news.onet.pl 1083501231 19399 213.134.164.126 (2 May 2004 12:33:51 GMT) X-Complaints-To: ab...@onet.pl NNTP-Posting-Date: 2 May 2004 12:33:51 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit