Please start performance counters for a period of time. If you doubt on mirroring, can you check "log send queue" and "transaction delay" counters on perfmon.

dm_os_wait_stats is a cumulative...

To obtain information per database level, run the below query against each database to obtain the usage.

SELECT TOP 25

obj.[name],

i.[name],

i.[type_desc],

count(*)AS Buffered_Page_Count ,

count(*) * 8192 / (1024 * 1024) as Buffer_MB

...

Did you restart the system aswell?? as its a mandatory thing to get the changes take place.

Can you try enabling it and restart the sql browser service?

Can you try enabling it and restart the sql browser service??

Would you mind checking if IPv6 has been disabled?

http://support.microsoft.com/kb/929852

first try to see, which database had took more memory on the sql server using the below query:

SELECT LEFT(CASE database_id

WHEN 32767 THEN 'ResourceDb'

ELSE db_name(database_id)

...

I had the same issue yesterday...restart of WMI service had fixed the problem and could complete the patch installation.

I have tried the same from development environment. It is working fine.

There is no network problem.

Before I check the option (close connection on package completion) the issue used to come...

Hi

Thanks for your reply.

The first task in DTS package is a batch file. It delete existing .txt file and then copies all *.csv files to .txt file.

The second...