One more observation is that below error is logged only after restarting the web logic application. Before restarting the application service, UPDATE was stuck on I/O, getting processed very slowly...

Thanks a lot for the replies. Finally, I could get the required result with your help.

Thanks every one for the prompt replies and sharing your thoughts.

id field given in the sample table is contiguous but in real data that I am working at, id field...

Thanks for the reply. How can I kick off the backup command asynchronously within PowerShell and then do some other work without waiting for backup to complete.

Thanks.

As a DBA, we all know that it is dangerous to grant CREATE/BACKUP/RESTORE privileges to non-DBA users in production enviornments.

My intention behind this post is how do we streamline access...

Not all users are allowed to do database operations. There is a specific group of 5/10 people (production/application support team) who supports 24*7 activities.

They are not DBAs but if there...

Thanks for all the responses.

Actual problem is DBA is available only 8 hours a day but support environment is open 24*7.

So non-DBA support technicians has to deal with DB...

Below is the procedure and this gets called from a top level procedure.

Thanks.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE procedure [dbo].[Iterator] ( ...

>What tells you that a new plan is getting generated on each call?

I could see a new plan handle in sys.dm_exec_procedure_stats. If it uses same plan, use count should increase.

Through sys.dm_exec_procedure_stats DMV, I figured out that despite using KEEP PLAN hint, there was a new plan generated for every execution i.e. plan was not reused. What is surprising though...

It seems there is no other way other than adding additional logging or working in a drill down mode starting from root stored procedure to the internal child procedure calls.

I just want to see the values that are passed during execution.

Thanks for the reply. Here is what we want to do.

We want to failover to mirror server and then run applications against mirror server for 2-3 hours

and failback to...

You should make sure that other files in the same filegroup has sufficient space to be able to move the data from the file being emptied.

Is the clustered index only index on the table? If there are other non-clustered indexes as well on the table, I won't prefer clustered index to be wide. In your...