Re: SQL Profiler - Reads and Writes

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: David Gugick (davidg-nospam_at_imceda.com)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 14:23:54 -0500

Kent Chan wrote:
> I have used SQL Profiler a lot. Recently, the SQL Profiler does not
> capture any reads and writes from one of the development servers, the
> reads and writes are always 0. It only happens from my PC to that
> server. It works from my PC to other servers. And other PC also works
> to that server. Only my PC. Anyone knows why?

Strange. The values are collected by the server, not the client. All I
can think is that you need to run the latest SQL Server SP3a on your
client to make sure your client tools are properly updated.

What happens if you run a server-side trace from your client. Do you see
the reads and writes then? 

-- 
David Gugick
Imceda Software
www.imceda.com

Relevant Pages

  • Re: telnet port 25
    ... In addition to what Bharat said, you might also try using a network sniffer, ... With such a capture, you can see what's happening on the ... Something between the client and the server. ...
    (microsoft.public.exchange.connectivity)
  • RE: Long Delays Interacting With Server
    ... you should capture at both points and compare to make sure there is no ... I assume the client here is asking for more data and the server is sending ... Would the 20 second timeout likely be ...
    (microsoft.public.windows.server.networking)
  • Re: Embed Mplayer into Web page.
    ... the client side. ... I used Gadwin to capture a frame from one of my videos playing from my ... turned the FTP client off and went back to the web page from which I ... capture on the server. ...
    (alt.html)
  • Re: form closing
    ... add code in the client side unload to notify the server (this requires an ... -- bruce ... >> You can use the onbeforeunload event of the body element to capture this ... >> client side. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Video-Streaming-Server
    ... On Thu, 2005-06-01 at 14:44 -0600, Les Mikesell wrote: ... You can either pass the capture output through ... Maybe I am just confused but I am used to having the client ... seem the server must push the content to the client. ...
    (Fedora)