Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL using tons of memory. Please help!

Status
Not open for further replies.
fncruz

fncruz

Programmer
Joined
Nov 30, 2001
Messages
1
Location
US

Hi:

SQL server is going nuts and using upwards of 90Megs of ram which slows everything down tremendously.

I used Profiler to see what it's doing and I get each of the following 2 messages:

SELECT N'Testing Connection...

and

EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters

The amount of Ram used by SQL server continues to increase.

Any suggestion on how to fix this.

Thanks.

FNC
 
Status
Not open for further replies.

Similar threads

MathiasB
  • Locked
  • Question Question
Parameterised sql server query
Replies
8
Views
885
Chriss Miller
C
elly00
  • Locked
  • Question Question
create sql view using batch file
Replies
5
Views
965
Mike Lewis
Mike Lewis
gbaughma
  • Locked
  • Question Question
SQL Performance
Replies
11
Views
1K
pjw001
pjw001
Steve Yu
  • Locked
  • Question Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN
Replies
3
Views
885
Chris Miller
Chris Miller
f0rg3tfu1
  • Locked
  • Question Question
PLSQL Package Help
Replies
0
Views
723
f0rg3tfu1
f0rg3tfu1

Part and Inventory Search

Sponsor

Back
Top