Hi Kenneth,

Sounds like you have found the source of your performance problems in that there are a number of very poorly performing queries, perhaps as you say, as a result...

Hi,

It may help if you could qualify what you consider to be a high disk queue and how you are measuring it.

Some details regarding your disk I/O subsystem would also...

Hi Jesse,

Sorry to hear of your difficulties.

I would suggest you take a look at the Performance Tuning area of Brent Ozar's site. It has some excellent tutorials on Performance Monitoring...

If you were to look to develop your own solution, perhaps you could start by investigating the contents of INFORMATION_SCHEMA.ROUTINES

The following article demonstrates how to search stored procedure source code...

Hi,

Thanks for the additional details.

I have a few more questions if I may.

To confirm, are all of your data files stored within the Primary File Group?

Which data file are...

Hi,

I can see your point and agree with you. Expanding your points, there are benefits to understanding the internals of how any given process works.

However, I am also a firm...

Hi,

Can you provide some additional details please.

How much free space do you have on the drive that the Primary Filegroup resides on?

What are the size of the the data files...

Hi,

You could probably develop a software application yourself in order to do this for you but I say why re-invent the wheel.

There are some great tools available in the market...

Excellent news!

Hi,

This is a long shot but you may wish to try running your select query using the nolock hint to see if that executes without issue.

If so, it would suggest...

Hi,

Take a look at the following post. It provides reference to what I beleive to be one of most robust SQL Server Index Defrag scripts and was written by Michelle...

There are also some excellent tools on the market that can automate this process for you and they are quite reasonably priced.

Take a look at SQLCompare [/url]from RedGate and Quest...

Hi,

Correct, once you have configured log shipping to provide transaction log backups for all of your databases you will no longer need your other transaction log backup jobs i.e. those...

Thanks for stepping in Markus, much appreciated.

Last time I checked, if you go the VMWare route, you would want to look to install VMWare ESX Server.

Cheers,

Hi,

Keep in mind that switching to BULK LOGGED Recovery Model will minimally log changes to the Transaction Log file however, your transaction log backups will still contain full details of...