Thanks Gail, yeah i have...

Thanks for the reply Grant, i agree but i have no other choice to try this if possible, as the queries are coming from a dll (which i cannot modify)...

Another cool article,

BUT it's not enough to satisfy me, becuase of two reasons, first we are running a third party product and that application sends direct queries to database so...

Thanks Krishna, very cool article, i just turned on the trace flag on my server, hopefully this will help.

But half of my confusion is still there, how would i know...

Where are the gurus??:)

Thanks for the reply, Yes i have Personal Edition.

But what is this limitation all about? and why is this error occuring? and what will be happening (with sql server, and...

I applied sp3 4035, but still i cant see the job steps.

Do we need to install service pack on client machine as well??

Yes, i have the sysadmin rights and i can see the job steps from other server machines. So it...

Nicholas Cain (12/12/2008)

---

You can either download a tool to perform these checks or you can run queries from a remote machine to check on the status of SQL and whether...

Thanks alot, this certainly is very useful information. Now what about 64 BIT? i am assuming that AWE is not required for 64 BIT, so how can i monitor the...

I have assinged max memory to 7 GB, so how can it be using 3 or 2 GB at max?

More over how can i find which switch is on?

No...

I am on 32Bit, but i am not using AWE option.

My Problem is different......i have set the MAX MEMORY variable of SQL Server to 7GB. Now i want to know that out of this 7GB MAX MEMORY, how much memory...

I monitored these two, but these two are almost static, i want to know the MEMORY sql server IS CURRENTLY COSUMING (say at a particular load time).

Thanks,

Usman

Jeff Moden, would you be kind enough to put here your those FEW INTERVIEW QUESTIONS?

Just wanted to check my own capability.

Thanks,

Usman