Keena,

Is there any chance you can send the SQL and the indexes on each table to
see if there's anything you might be missing in terms of performance and
tuning with the queries themselves.

Regards
Christine
DBA
PricewaterhouseCoopers, Manchester





"Ferguson, Keena"
<[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
com> cc:
Subject: Dilemma
18/09/2003 20:07








Hi all,

Does anyone know the answer to this one ... Can't find anything in BOL to
help ...

Several queries come into SQL server from another server running Web apps
... These are queries returning thousands of rows after selecting from 5
joined tables containing 11 to 12 million rows a piece ... These are
memory intensive queries ... Once the query has finished and tries to go
back to the calling server, the calling server is locked up and and does
not
have the umph to respond ... What happens on SQL Server ... Do the result
sets remain in memory? ... If so, for how long ... We have 8gb of RAM on
this server and still at times seem to be running out of memory (or at
least
that's what we are seeing in SQL Profiler) ...

Thanks in advance ...

Keena Ferguson

Sr. Database Administrator
Comdata Corporation
[Email Address Removed] End of message text --------------------

This e-mail is sent by the above named in their
individual, non-business capacity and is not on
behalf of PricewaterhouseCoopers.

PricewaterhouseCoopers may monitor outgoing and incoming
e-mails and other telecommunications on its e-mail and
telecommunications systems. By replying to this e-mail you
give your consent to such monitoring



MS Sql Server LazyDBA home page