SQLCrazyCertified (1/4/2013)
SQLRNNR, There are only 50 active connections.....so, I don't think this is the issue.Joie Andrew, Had complains that everything is running slow and I coudn't find anything else other than SQL using all the memory which is allocated to it.
GilaMonster, I am not 100% sure if it's only memory related, however, I am stuck as to what's the next step....not an exper on performance tuning.
Grant Fritchey, I did select * from sys.dm_os_wait_stats, now which column should I focus.
I really appreciate all of you for giving me valid inputs as to where/what should I be checking. Could this be a CPU issue as well?
Thanks,
SueTons.
Connections to the database take resources and do consume memory. That added to the waits that Grant asked about would help to understand memory pressure.
Did you check with your users to find out where the app is slow?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events