It seems there is no issues with SP, the issue is with application code which may cause lock or deadlocks . Can you try using profiler with lock events and...

Hi

Thanks for link, I tried ussing ring_buffer_type = 'RING_BUFFER_RESOURCE_MONITOR' as well but not able to find anything in these DMv's before sql restarted.

Seems no other go...

can you execute query from ssms

1. from ssms on your machine

2. from ssms on database server

3. from ssms on application server

Is the output coming in same time ??

Hi

I am also first time trying to use these for analysing issue for alert in error log (A significant part of sql server process memory has been paged out).

What exactly...

Summary !!

By default, SQL Server updates index statistics automatically. Frequency of automatic updates depends on number of rows in the table. If you allow SQL Server to update statistics automatically...

First i increase size of datafaile by 500 Mb but i recieved same error , but next time when i increased same by 1 MB it worked. Thanks

In one...

So how does sql server identify Minimum LSN for database recovery ie LSN of the start of the oldest active transaction. What process does sql server follow. Can we...