Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Memory Tuning Rss

   Items 1 to 3 of 3   

Determine SQL Server memory use by database and object

For many people, the way that SQL Server uses memory can be a bit of an enigma. A large percentage of the memory your SQL Server instance utilizes is consumed by buffer pool (essentially, data). Without a lot of digging, it can be hard to tell which of your databases consume the most buffer pool memory, and even more so, which objects within those databases. This information can be quite useful, for example, if you are considering an application change to split your database across multiple servers, or trying to identify databases that are candidates for consolidation.  Read more...
By Additional Articles 2011/06/01 | Source: | Category: administration
Rating:  Rate this |   Briefcase | 4,450 reads

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: | Category: memory tuning
Rating:  Rate this |   Briefcase | 4,333 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,734 reads
   Items 1 to 3 of 3   
performance tuning (2)    
administration (1)