Profiler to local disk files, then load into database for analytics. Do it all the time. Very light weight going to disk. All you need is tsql/rpc...

1) this looks like it could be a VERY complex undertaking and thus is not really appropriate for a forum question. People here volunteer their time and involved questions...

For the query that is taking 3 seconds, show the Actual Execution Plan when you run it and then let us know what the Estimated and Actual row counts for...

1) don't try to return this much data to a client tool. just won't work

2) you best have a VERY large and VERY fast tempdb IO subsystem to throw...

Ninja's_RGR'us (10/27/2011)

---

GilaMonster (10/27/2011)

---

Ninja's_RGR'us (10/27/2011)

---

Don't you love the smell of backstabbing in the morning? 🙂

Note to the <non hiring> op. Both these 2 seem to love using knives while...

To the OP: you can spend days or even weeks trying to hunt down performance issues if you aren't trained/skilled/experienced at doing so. Or you can do as others...

Lavanyasri (10/26/2011)

---

HI Kevin,

Thanks for the update .

I think u r right , it might a problem with Cursors. I ran a profiler with rpc completed ,sp:stmt completed ,SQL...

As has been said already, DBCC memorystatus will give you detailed output on memory usage. It is officially semi-documented online.

You can use dbcc memorystatus (officially documented online) to get detailed information about memory use in SQL Server.

It is quite exceptional for SQL Server to be CPU bound instead of...

Partitioning is an ADVANCED feature and you will very likely get yourself into unfortunate situations/scenarios if you ask for a few pointers on a forum, read a blog post or...

I believe Books Online has good instructions on how to enable AWE and large memory access on 32 bit systems. I would also look at dbcc memorystatus (documented online)...

Here is a blog post from Jonathan Kehayias with some interesting testing: http://sqlskills.com/blogs/jonathan/post/Does-Index-Fragmentation-Matter-with-SSDe28099s.aspx

Check out SQL Sentry's Event Manager.

And for the actual maintenance itself you absolutely should use ola.hallengren.com's scripts.

Tell them both that TheSQLGuru sent you! 🙂

never, ever use maintenance plans! get the awesome free and fully documented maintenance suite from ola.hallengren.com.

Additional guidance can be found here (http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx)