I was just reading about monitoring latch waits over on Paul Randal's blog. He suggested this white paper to understand what's happening with latch waits..

So when do you need the old value again? I don't completely understand.

+1

And, you have to determine what defines "long running" on your system. On mine it might be when a query breaks 60 seconds. On someone elses it might be 60...

In general, in these situations, I nest stored procedures. It's not like nesting views or functions, so performance should be fine. Check the execution plans of your queries to be...

Just understand, it's a common misconception, but putting in READ UNCOMITTED or NOLOCK is not a "run faster" switch for SQL Server. It can increase some performance in some areas,...

GilaMonster (9/2/2011)

---

Lesson 1 in perfmon. Most counters don't have hard values of good and bad. What you need to watch for is values that are very different to what's normal...

Page life expectancy shows how long pages have been in memory. That's it. A long time is good. The longer the better. I've seen weeks without a page flush before....

It's going to be nothing but GUIDs pointing out to some file location somewhere.

jared-709193 (8/31/2011)

---

Run SQL Server Profiler and filter the database name to the one you are interested in. Monitor it for as long as you see fit to determine usage. ...

You can look at queries in the cache to see if the database has been accessed recently: sys.dm_exec_query_stats. But that's only as good as the queries in cache. If the...

If you have a slow query that you've already identified as the point of pain, take a look at the execution plan for that query. That's going to tell you...

First, why insert twice? That's two times the labor and work for SQL Server.

Second, have you looked at the execution plans? That will tell you how things are behaving and...

You mean a user defined function in TSQL? That's just another way of writing a query (assuming we're not talking table valued user defined functions). There isn't, per se, a...

What are the statements after that in the transaction?