The issue is that the server's RAM is utilizing up to 59 GB out of 64 GB.So the another DBA has discussed from somewhere and on the dedicated drive of...

He is saying To clean the buffer,Cache,Close the existing connections.

May I Know how to close the existing connections in command...

Actually I am taking handover from a dba and he has written refresh of database in his kt so I am not getting it ....

I mean to say refresh of already running production database.

I want to do the load testing for this 10 gb MEMORY.

How can I do this..

Have u some code..

Should I enable awe also??

It is a 64 bit server.

My question is this.

Thats the confusion why Microsoft has written this long value??

Awe is not enabled it is 64 bit.

In perfmon How Can I dead sure that another cpu is required for better Performance..

Hi Brian,

I am finding "BOOST SQL SERVER PRIORITY" setting but not "USE WINDOWS NT FIBERS" in sql server 2008.

Where is It?and How WINDOWS NT FIBERS are useful in performance?

We have applications are:

SFS,SUNGL,Payroll,MOSS,Biztalk,NewGen,FIM

for these applications have any idea...

Use the command with "Without Login"

If I want to create a login with insert view update and delete permission.. How Can I give these permissions to a login...

A user without login..go db-->security-->right click users--->User's properties is showing without login...

A new user always created with Login name.

Yes dear...Hmmm