mohammed moinudheen (2/9/2011)

---

You won't be able to take the backup directly on to your local machine.

First let the backup command run to take the backup on server location

and...

If you know which procedure is causing problems, get that query's plan handle and use DBCC FREEPROCCACHE(plan_handle). That way you're not nuking the cache, but going for surgical strikes.

There isn't a way to write a single query that will gather all the information needed. Like the link to Brent's site shows, you're going to, at a minimum, hit...

Yep. My book covers a pretty hefty chunk of what you're asking about.

Tom.Thomson (2/8/2011)

---

I've joined...

sqldba_icon (2/8/2011)

---

Grant Fritchey (2/8/2011)

---

sqldba_icon (2/8/2011)

---

Two updates on the same question,

i) In my proc i have the following options set up

Set ANSI_NULLS ON

go

SET QUOTED_IDENTIFIERS ON

go

Set Transaction isolation level read uncommitted

SET NOCOUNT...

sqldba_icon (2/8/2011)

---

Two updates on the same question,

i) In my proc i have the following options set up

Set ANSI_NULLS ON

go

SET QUOTED_IDENTIFIERS ON

go

Set Transaction isolation level read uncommitted

SET NOCOUNT ON

ii) This article...

Gianluca Sartori (2/8/2011)

---

Grant Fritchey (2/8/2011)

Hey, while I've got you guys here, when I was off the network, the Virtual Box and the laptop stopped communicating. I'm sure I've got a...

Assuming you're getting an actual execution plan from the trace or through management studio, they're the same because they're coming from identical sources. Neither does anything that the other does...

If it comes out on schedule, it will be SQL 2011, yes.

parissa_bakhshi (2/8/2011)

---

1-Sure,I've used perfmon and every things seemed ok, except context switches.

and also memory , but SQL always takes the memory till a process need it. goof buffer cache hit...

Bungholio (2/8/2011)

---

Thank you - I'll look into that. In the meantime I figured that the memory cosumption of sql is extremely high and eats up all of the available memory...

ericwenger1 (2/8/2011)

---

I'm a dba at a shop that uses alot of embedded dynamic sql and I concerned about whether the dynamic sql will use a cached query plan. I'm an...

Check this article from SQL Server Magazine. It shows how you can query msdb tables to see backup information. It won't tell you how the call was made, but it...

parissa_bakhshi (2/8/2011)

---

How can I find which I/O is problematic? Is it memory which is unable to respond to paging request in a timely fashion? disk and memory delay in transfering...