Hi Paul,

I guess I am failed to express what I want.

I do understand that in addition to the performance; if small extent is set to autogrow i.e. 250 mb or...

Hello Paul,

I guess operation may not fail in most of the case but yes it might fail due to unavailability of the space. I guess mostly it get delayed and...

Use windows performance monitor.

Hello Brad,

It's always good to have proactive work.

Also I suggest that instead of running select @@version you can check the services of the sql server instance. You can refer the...

What if you do finetune the development things like SP, Triggers, Business logics/Rules etc... does it improve the performance???

I guess if everythings are scattered and not maintained; it's always better...

Hello Duran,

Yes it's quite possible....

Modify the Maintenance plan... in the design right pan top tool bar click 'Reporting and logging' (beside Manage Connections) and specify the path in 'Reporting'.

HTH

Cheers!!!

I do agree with Glenn only users need to be mapped elase do nothing.

When you will do reindexing and update statistics the environment will change compare to production and what...

While you change the compatibility level of my database from 80 to 90. It's always good to test each and every Stored procedures, function, triggers, Buisness rules etc. in your...

Hello '2 Tim 3:16',

Nice solution We can cerate the link server and surely it works but what if customer do not agree for link server?

Also due to some security issues...

Thank you, John.

Your query works but in case if SQL server is down we won't be able to track it.

So any solutions are welcome; when SQL server stops 🙂

Thank you Adiga & rlondon.

Yes both of your reply will be useful.

Paul you hit the bull eye buddy 😉

You need to add "Maintenance Cleanup Task" with desire retention period of Database...

What sql server Service Pack are you using?

DC, you bang the target profiler will tell you everything 😉

I guess in your case backup threshold value is greater than log backup intervel.