Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Performance Tuning, Memory Tuning Rss

   Items 1 to 2 of 2   
 

Are Your SQL Server Application Queries Wasting Memory

I am running an application that issues queries directly to the database from within its source code. I've noticed that the database server will get low on available memory and that CPU activity is higher than I'd like. What could be the problem?  Read more...
By Additional Articles 2008/12/04 | Source: MSSQLTips.com | Category: memory tuning
Rating:  Rate this |   Briefcase | 4,207 reads

SQL Server memory configurations for procedure cache

SQL Server expert Denny Cherry explains how SQL Server determines how much memory is used for procedure and buffer cache and how you can allocate available memory.  Read more...
By Additional Articles 2008/06/27 | Source: SearchSQLServer | Category: performance tuning
Rating:  Rate this |   Briefcase | 3,491 reads
   Items 1 to 2 of 2