SQL Clone
SQLServerCentral is supported by Redgate
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,486 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 | 4,078 reads
   Items 1 to 2 of 2