This (performance) is the area time to time I struggle with. Couple of days ago, we had an issue where all of a sudden, an application started running slow. I was told to look into it from a SQL Server side and I couldn't find anything (atleast from what I know) because all the available resources looked good, no locking, stats were updated, indexes were rebuilt a night a before so I wanted to rule out that it wasn't the SQL Server issue but the application server issue. Front end developers restarted the web server which resolved the issue. This has happened couple of times and we can't just seem to find the issue. Before I can be sure that this is not a SQL Server related issue, how can I be certain? What other things I should look for before I send the team an email saying 'It isn't the sql server'.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]