5 recompiles for 1000 batches is pretty good. 50% compile rate on your batches suggests that you've got lots of ad hoc queries. If it's a reporting system, that ratio...

For only 5, I'd say roll your own. You get most of what you need from Perfmon & server-side traces. Spending money on a tool for so few servers seems...

mjarsaniya (6/30/2009)

---

I am new to sql server .....but from this topic I understand/decide that ,

you are beginner or expert , first do best try to get answer from BOL and...

There really is no way to accurately assess how long a query will take to run. You can have a single row update that should run in about 5ms that...

Pretty sure that's from an encrypted database Roy. I posted on it.

Sounds like the database was encrypted. It wants the location of the key files and you'll need the passwords that unlock them.

All those functions on the columns in the JOINS are going to kill performance. They should have in 2000 as well. Can you post the execution plan?

Two options, identify indexes that are not used or that are too big and eliminate them, as per the previous post. Another option is to upgrade to 2008 and use...

There is also a lite version of AdventureWorks that includes simpler structures and less data, so that's another alternative (not better, just different) to Northwind. There's also an AdventureWorksDW that...

It's a secret admirer.

mazzz (6/30/2009)

---

Thanks Grant.

I remember reading about the cost figures being estimates, even in the *actual* execution plan - what would one look at instead, to figure out which bit of...

That would be a WHERE clause within a...

Yes, it was taken down pending an investigation of violation of the DMCA. Here's more detail [/url]for those that are interested.

Passthrough or not, when you send a query up to SQL Server, it gets converted into TSQL syntax because that's the only syntax that SQL Server understands. Although I thought...

The question is, how much money do you want to spend. The two tools that I use to do this are System Center Operations Manager from Microsoft and SQL Diagnostic...