Hello Jasona,

Thanks for your answer, Do you mean to say those are no: of pages that is same as total_pages_count in sys.dm_db_file_space_usage, But why did Microsoft gave column...

I Have seen the information from DBCC PAGE where i am not have inforamation below structure of 

1 Byte for STATUS BITS1 + 1 Byte for STATUS BITS2 +...

Thanks much, As i have to archive the database i need to store the backup of database on other server for next one year, i was in a confusion whether...

Good Question! Logins which doesn't match their sid in SQL Server login and User database or A login exist in user database and not in SQL Logins this will give...

So i can apply most recent SP3 to my RTM SQL Server, do i need to stop SQL Server services(SQL Server and SQL Agent, Browser Service etc..) when i am...

Thanks for answering,

Now i understood there will be a buffer pool with data, free pages with 8KB buffers and plan cache and data cache where SQL will load the...

Log shipping would be good and easy to to keep the minimal downtime to swithover.

Thanks for your time I got the answer, There is no need to restart the SQL Server services if we change the Cost Threshold Parallelism value from 5, If estimated...

If i change that value to [highlight="#FFF000"]50[/highlight] do i need to restart SQL Server Services on production.

cost threshold for parallelism is set to 5.

After Setting 50 GB and now my Physical memory is 54 GB i don't know whether it will stop here, it is goes to 63 or 64 GB by tomorrow,...

Thanks to every one who answered my questions by taking time.

Okay can you please suggest me how much sizes of tempdb data files(Max = 8) should be added for...

we have 64 GB of Physical RAM, we had set 50 GB as Max and 4 GB as Min, and even we are facing an issue that SQL Server is...

Thanks for your answers, i had set my Max memory setting to 50 GB and now Target Server memory is showing as 51452 MB in performance counter so now i...

If we say say MAX memory setting is 60 GB in SQL Server and does it mean 4 GB left for Windows?