Hi

Thanq...

In fact .... i already installed that older version of SP2 which already upgraded some of

components except notification and Client...

Can we re-install the new SP2 file on already...

No, The file which was available on MS Web site is not same as the file which is

available now as they found some bugs .......

Please check the link...

Hi

Thankq for your reply!

I installed SP2 just 2 days back (but downloaded it before mar 5th) ... but it failed to upgrade the Client tools.

I found them not upgraded...

Hi,

Thanking for ur response!

I found total server memory as 6GB, that is ok with me!

But, perfmon output for the same counter as well as total target memory is 6GB...

Hi

I can have some what performance improvement by enabling the AWE, right?

because, we have RAM around 8GB and we have no other application installed on this Server and

it is...

Thanq kishore , Thanq Vey much

I will be updating you as soon the performance gets improved..

Regards,

Naga

Thanq Kishore..

sp_configure 'min server memory', 1024

RECONFIGURE

GO

sp_configure 'max server memory', 6144

RECONFIGURE

GO

In the preceding example for SQL Server and Windows Server 2003, the memory settings direct the buffer pool to dynamically manage...

Thankq Kishore!

And one more Doubt ..

We have Windows Server 2003 EE 32-bit X-86 and SQL Server 2005 EE and RAM about 8GB....

I am gonna specify like below,

Minimum Memory : 2048G

Maximum...

Thank you Kishore! Thank you very much!

I never gotta know that SQL Server can only use 2G of RAM for its Cache Memory.. This is really good.

So, AWE is an...

Thanq

I still have a doubt on my mind!

What exactly this AWE?

Is this additional memory other than RAM and Paging memory?

How SQL Server uses it? How about RAM then and...

My Remote Query Time out and Query wait found set to Default

as well as

Minimum Memory per Query is also found Default (1024KB)

and more over

How about AWE? How can...

Hi Mani,

Thanking u 4 ur post......

In fact, i am very much new vth SQL Server. I have been learning it.

Instead, I am Oracle Certified Profeesional. My client has challenged me...

what our HP vendor was saying that, we can expand the LUN, but SQL Server 2005 has some formatting issues. As per the HP Storage is concerned. it is HP...

Hi all,

And more over ...the Database clusterd ...

How to move clustered Database files then?

Thanking you

Hi ..

Thanking for ur post.....

The link below has given me the solution....in the test server..in my lap top....

i waz able to move the files from one location to another location