January 31, 2013 at 12:43 am
Experts - I have few doubts over below statements. Please provide your inputs.
1) In task manager we always observes that sql service is consuming more memory than actual. Why does it show more memory in task manager? And which more memory it shows?
2) Which memory linked server uses - Is this that memory which is allocated to sql server of any other OS memory?
3) I know without primary key transacitonal replicaiton is not possible. But why do we need that primary key?
Thanks in advance.
January 31, 2013 at 4:45 am
beejug1983 (1/31/2013)
Experts - I have few doubts over below statements. Please provide your inputs.1) In task manager we always observes that sql service is consuming more memory than actual. Why does it show more memory in task manager? And which more memory it shows?
Do not use Task Manager to monitor SQL Server memory, use Performance Monitor counter SQLServer:MemoryManager\Total Server Memory, as memory used by SQL Server is not always accounted for by Task Manager under sqlservr.exe.
2) Which memory linked server uses - Is this that memory which is allocated to sql server of any other OS memory?
It comes from the Virtual Address Space (VAS), which is also known as MemToLeave. This memory will be accounted for under the sqlservr.exe in Task Manager.
Chapter 4: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/[/url]
3) I know without primary key transacitonal replicaiton is not possible. But why do we need that primary key?
In Transaction Replication it is important that SQL Server be able to uniquely identify a row when it moves from the Publisher to Subscriber and the Primary Key is used to accomplish it.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply