Ok. Thank you.

Thank you. It says the Login is NT Authority\SYSTEM. If it is SQL Sentry, it would show SQLSentry Login? we do have a separate login for SQL Sentry. The application...

Thank you, Jeff. I am trying to understand what causes the server to be unresponsive. We received several timeouts when the server became unresponsive. Can Blocking or Deadlocks cause the...

Hi Jason, Thank you for detailed explanation. I ran the query and turned on Actual Execution Mode. Following are the results. I see that the Estimated number of rows is...

Hi Jeff, I will look into that. But, I am still curious to know if there is a performance difference between the two queries.
Thank you.
Sridhar.

Hi Grant,

It is a simple query. Let’s say I have table A with columns Id, Empno, Punchdate. The primary key is on Id field. It is not set as auto...

Hi Sue,

Thank you for the reply. We have Blocking SQL tab as part of SQL Sentry Subscription. I can see that all the queries / SPs that are...

Thank you for your input. I understand that upgrading the server is the way to go. Before we go that route, I just wanted to make sure if there are...

As of now, we have 127 databases. we typically add 1-2 databases every month. If clients have been with us for long time and depending on the size of the...

Hi Sue,
Thank you for your response. The databases are different sizes. The biggest one is 100 GB. Lot of them are over 50 GB. we are restoring the database...

The issue is since we have several databases, by the time it restores all databases, it will be around 9:00 AM next day.

It seems to be interesting but expensive. Are there any other solutions?

we start the restore in the night but since we have several databases, it completes in the morning.

Thank you for the solutions. I will look into them.

Hi Gail, Thank you for the code snippet. I thought that when you open the transaction (BEGIN TRANSACTION), all the tables inside that block will be locked until the transaction...