Showing posts from April, 2011

Suggested Max Memory Settings for SQL Server 2005/2008

It is important to make sure you set the Max server memory setting for SQL Server 2005/2008 to something besides the default setting (which allows SQL Server to use as much memory as it wants, subjec…

Use sys.dm_os_performance_counters to get your Buffer cache hit ratio and Page life expectancy counters

Buffer cache hit ratio This means what is the percentage that SQL Server had the data in cache and did not have to read the data from disk. Ideally you want this number to be as close to 100 as pos…

script – percentage of identity values being used

Here is a script which list out all the identity columns and percentage used   SET NOCOUNT ON SELECT SCHEMA_NAME(t.schema_id) + ' . ' + t.name AS TableName, idc.name AS ColumnName,…

Index Fragmentation on Partitioned tables

Partitioning can be effectively used to break up a very large table into multiple partitions based on a column or partitioning key. However, there can be significant management overhead in maintainin…

Find the Size of Database

I encountered the situation recently where I needed to find the size of the database. --size of database SELECT DB_NAME(database_id) AS DatabaseName, SUM (( size *8)/1024) SizeInMB FROM sys.mas…
Subscribe Our Newsletter