This set of article by Gail is one of the best for analyzing query performance and otimizing them.

Find out queries which are taking longer time and try to optimize them.

Is the server capable enough to handle the load you're putting in?

Are there fragmentation in indexes?

Are the statistics...

Use windows performance monitor tool(perfmon) or use dmv sys.dm_os_performance_counters.

douwe.rijpsma (12/1/2010)

---

Is it possible to exclude deletes from your primary database with LOG SHIPPING ?

Expl: I have 2 databases: DB1 on server1 and DB2 on server2. I want to keep...

Or is it that since this is a maintainence statement (not a DML query), it didn't have a plan in the plan cache and hence no plan_handle?

I've read that relation...

can you be more clear on your question.

if a job is disabled, it wont run and hence wont perform the task it was supposed to perform.

after more than 12 hours, that session is no more active. no open transactions in msdb. log size came back to 45 MB. Nothing done from our side:cool:.

Ok. here is the query. May be you guys can help me better this. Or tell me what all things should i exclude/include.

-- Script written to find and report long...

Thanks Craig. 🙂

As of now i have written a script that emails a set of users whenever a query crosses the threshold (which is 8 minutes for them). It is...

Thanks for your reply.

There is an application whose command timeout is set at 8 minutes. App team thinks any query taking more than 8 minutes should be timed out....

a_ud (11/24/2010)

---

Usually, when you want to avoid compilation of a command or 1-2 lines, you add the double line '--' to your code, making it a fake 'comment'.

How can you...

sys.dm_exec_query_stats gives you cummulative stats for query plans that have been executed.

Trace will suit your requirement. Run a trace during that time and sort on duration to see which all...

You could have opened a new thread for your query since this thread is too old.

SQL 2000

I want to run a backup of...

jolan.mahinay (11/23/2010)

---

we restore the file from the bin then the status of the db is in recovery\read only, what would be the next step cause when we try to right...

run the code provided by franco in the previous post. This would give you an idea of how much space is allocated to the mdf and ldf files. Backup size...