Thanks to RTalor & Gail Shaw for your valuable response.

@RTalor : Can you please share the list of counters and their threshold values to have baseline for the system.

How...

Thanks but I have gone through the link.

Thanks

Vinod

Thanks for the reply.

I have attached out put of this query in excel format.

So then SQL max server memory = Sum(SingleP_MB)+Sum(MultiP_MB)+data cache memory.

Please correct if I am wrong.

Thanks again to...

Thanks for the reply Gail.

so bpool_commited is the only consolidated way to describe the memory usage out of max server memory setting.

Any reference to calculate memory of all component will...

Hi,

Thanks for your reply.

Out put of your query is 35GB which I have set for max server memory.

I got some query from blog of SSC only which give the utilization...

Hi,

@Gail: One question on this as suggested by you. Does it make sense to set max sever memory for this particular issue?

However I going through link and the pdf doc...

There is no spatial datatype the sql is 64 bit.

Hi All,

Thanks for all your responses. I was out of office for couple of days.

@springtowndba : These are the details for your reference the total RAM on server...

Thanks Gail for this valuable information.

Really appreciate your efforts.

Thanks Gail for your quick reply. I was expecting the expert comment on this.

Can you put some light why it has happend (If you have any idea about it).

Thanks for...

Hi Divine flame,

Please correct me if I am wrong, I am not able to connect to Production box so for this do I need to make entry in Production box's...

How it will help if I put entry in the host file which on dev?

My question is We are not able to connect to xxx-xxxx-PROD\SQL2008P instance through SSMS to which...

Hi,

I checked the server name from computer properties using @@servername.

The computer name shows xxx-xxxx-PROD

@@servername = xxx-xxxx-PROD\SQL2008P.

We are able to connect through xxx-xxxx-PROD or IP address.

But we are not able...

I think IP is not changed.

I can connect through IP from any where but can not connect through server\InstanceName.

Thanks

Hi,

Thanks for the response, Firewall is off the server. The port is 1433.

As suggested by you, I use sqlcmd and here is message.

HResult 0xFFFFFFFF, Level 16, State 1

SQL Server Network...