for CPU utilization use sql alert. In SQL alert we can set whenever cpu utilization increases beyond the specified range. In that alert message try to execute a job ...

Download the attached file and then execute. I think while copying you missed some code. For me it worked properly.

Hi Ritesh,

I also implemented these automation on our servers. I think you missed few more things like when new db created, dropped and altered on the server, reading sql server...

Other than schema binding we can use DDL trigger to do this task. You have to right a DD L trigger on database which checks whenever you are changing the...

if you are using a profiler in production server its better to use the dmv or dmf.

Take the backup of database and restore that database in another server.

It depends on the SP logic.

1) If your SP contains statements which is repeating through out the SP then create Separate SP for those statements. In this case creating Nested...

We don't have task pad in SSMs. We have to use SP_helpdb it will give the size of all the dabases. if you want further details then pass individual database...

Check the performance in below sequence.

> Is joins are correct in the query

> check for subquery or corelated query in your query

>what are the other process running at that point...

Its only in oracle

Hi All,

Now we can move resource database also. Please refer the link below in MSDN.

http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx

thanks

Hi,

In 2000 we can run dml operation on the tables. Get the job id and delete the corresponding records in the child tables. It works fine. In 2005 we have...