Forum Replies Created
Viewing 15 posts - 1 through 15 (of 21 total)
-
RE: Database file size calculation
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...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Save a tree... Please don't waste paper unless you really need to!
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: How does a integer/any data record store in SQL Server page
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 +...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: Backup Set will expire - Backups
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...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: Find Orphan users for each database in a given SQL Instance
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...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: Service Pack Updates for SQL 2012(Denali)
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...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: Buffer Pool - Buffer Cache - Buffer Cache hit ratio (Confusion between three)
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...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: Moving a large number of databases from one server to another?
Log shipping would be good and easy to to keep the minimal downtime to swithover.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: Max Degree of Parallelism - 24 Core processor 2 NUMA nodes
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...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: Max Degree of Parallelism - 24 Core processor 2 NUMA nodes
If i change that value to [highlight="#FFF000"]50[/highlight] do i need to restart SQL Server Services on production.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: Max Degree of Parallelism - 24 Core processor 2 NUMA nodes
cost threshold for parallelism is set to 5.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: SQL Server Memory Configuration calculation
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,...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: CMEMTHREAD Wait type - need explanation and solution for this
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...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: CMEMTHREAD Wait type - need explanation and solution for this
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...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: SQL Server Memory Configuration calculation
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...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
RE: SQL Server Memory Configuration calculation
If we say say MAX memory setting is 60 GB in SQL Server and does it mean 4 GB left for Windows?
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
Viewing 15 posts - 1 through 15 (of 21 total)