Re: SQL Server 2000 query time out option, what does it do?

Query timeouts are confusing. The most common is from your client to
the server. If the client initiates a query, and that query takes too
long, the connection can timeout. As an example, poorly written code,
or a slow server can take a very long time, and the client will time
out. Usually it is the client that times out.

I would assume that one server talking to another woudl use a similar
connection which could time out.

.

Relevant Pages

  • Re: High CPU in client (Excel, OWC, Proclarity, etc.) accessing Analysis Services
    ... We have encountered similar problems not limited to Excel, but every client. ... occur when there are many dimensions nested on each other on a single axis ... > Performance Guide to optimize the query, the cube, the server, etc. ... > While the query was grinding, the server was doing absolutely nothing. ...
    (microsoft.public.sqlserver.olap)
  • RE: LDAP query for xerox 3545 printer/scanner blocked by SBS 2003?
    ... Client and printer pointing to SBS for DNS ... LDP query from another workstation was successful ... Step2:Please ensure the DNS on workstation is pointed to SBS server. ... Monitor will capture some packets which pass through this interface. ...
    (microsoft.public.windows.server.sbs)
  • Re: public distributed filesystem
    ... You have a simple server which keeps track of client ... >>whether a peer has honestly kept your data block ... respond to any checksum query is to essentially store ...
    (comp.os.linux.misc)
  • Re: Parameterized Query
    ... The only point for a parameter, client side, is the where clause and you ... benefit from execution cache plans on a server like SQL Server. ... if the sql in the sproc is fully qualified. ... Assembling the query, client or server side, will take very few cycles. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VLDM Slow performance on Client PC
    ... from the server to the client. ... you can force the execution of the query on the server side rather the ... it creates another system process to hold the dimension in memory. ...
    (microsoft.public.sqlserver.olap)