Hi,

Thanks to all for response, however problem still there..

SQLRNNR : Yes, Taken database backup in compressed form on local disk

Michael : I have also taken backup using compression on Network..Ist...

Hi,

You can find the culprit by checking the WAITSTATS, when ever the slow response is felt on the server.

Use

DBCC SQLPERF(WAITSTATS)

or

Select * from sys.dm_os_wait_stats

Regards,

Ankur

Hi Perry,

You are right...again checked server..last time server rebooted but no gains...then I remove & reset the 'lock pages in memeory' and 'Sp_configure AWE' settings.

Last saturday, when again server rebooted...hurray...got...

Hi Perry,

Thanks again for providing response. 🙂

When I checked error log, there is only one message related to AWE i.e.

" Set AWE Enabled to 1 in the configuration paramenters to...

Hi Perry,

So you mean to say, that in Boot.ini file:-

--------------------------------------------------------------------------------

[boot loader]

default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS /PAE - ONLY HERE /PAE IS REQUIRED

timeout=30

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /sos...

Hi Perry,

We have Windows 2003 Enterprise Edition with SP2. Contents in Boot.ini are mentioned below:-

[boot loader]

default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS /PAE

timeout=30

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /sos /bootlog /noexecute=optout /fastdetect /PAE

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="HP SMP Preserved:Windows Server 2003,...

Hi,

Sorry forget to mention it...it's 32 bit system, madam.

Regards,

Ankur

Hi,

Thanks a ton Ninja_RGR !!! for the continous help and clarifying doubts.:-)

With regards,

Ankur

Hi Ninja_RGR,

Thanks again..

In my case unallocated space is very huge (almost near to the size of 48 GB) i.e.:

Database Size Unallocated Space

45825.60 MB ...

Hi,

To ensure current values are returned, use:-

USE DB Name;

GO

EXEC sp_spaceused @updateusage = N'TRUE';

GO

Try it and find out the database size. Hope it works..

With regards,

Ankur

Hi,

Thanks Ninja_RGR for the wondeful link.:-)

Just to be equipped of the meaning of different terms, can you please explain more about the Terms involved in this output of Sp_Spaceused command?

With...

Thanks Ninjafor the response.

As this huge size of Tempdb is occupying major chunk of hard disk space and leading to free space issues, the server has been rebooted and now...

Hi All,

Please help and provide your valuable thoughts on this topic..

Thanks in advance.

regards,

Ankur

Hi,

Are u getting the same error when connecting using the SQL Authentication?

Becasue from SS2008 onwards, Biultin Administrators donot have SA level access to SQL Server as it used to be...

Hi,

Yes, DB Mirroring can be implemented on above mentioned edition.

FYI..

Also, on a 32-bit system, database mirroring can support a maximum of about 10 databases per server instance because of the...