robin.pryor (3/27/2014)

---

Sean Lange (3/27/2014)

---

robin.pryor (3/27/2014)

---

MarkusB (1/7/2009)

---

You call yourself SQL DBA and ask such...

If you're going to use sys.dm_exec_requests to monitor, you'll have to capture it over and over again then write a query that shows the changes over time. As far as...

I think Igor largely nails it. I'd concentrate the aggregations into the view. That's the stuff that is going to be the most costly in your queries, so doing that...

I don't that Profiler is the best tool. In fact, Profiler, the GUI, is a somewhat dangerous tool to point at a production server. It can actually cause performance problems.

My...

Assuming you're trying to replicate the production environment, I'd have whatever type of fragmentation management you have in production in place on the test machine. Same with statistics maintenance and...

Ola and Michelle. Anything else is a waste of time.

Cost alone? Nah, surely not. Not that SQL Server is cheap any more, it isn't, but DB2 is hardly the low cost alternative. It's either politics, or some other piece...

Oops. Instead of server there at the end, I should have said instance. That's more accurate.

Yes, 2012 has the shared disk cluster through the Failover Cluster. Same as before. You can also have Availability Groups, but they're actually a separate thing to set up and...

ONLINE index rebuild uses both memory and tempdb to keep the index online while the the rebuild process occurs.

I don't know Ola's scripts enough to help out.

tony28 (3/26/2014)

---

Thank you.

My boss said me about it, I said him this solution today morning, but it can be problem with cpu and first few minutes can be slowly... but...

Memory should manage itself, really. But if you need to clean a query out of the cache, you can get it's plan_handle value from sys.dm_exec_requests or sys.dm_exec_query_stats and then use...

paul.knibbs (3/26/2014)

---

Seems I should clarify: I said it wasn't a totally unreasonable position, not that it was a position I agreed with. Wanting cross-compatibility between different database platforms is something...

Contact Microsoft, from whom you have a license, right? They'll give you a link to download it.

No, it won't cause the service to restart. SQL Server is smarter than that. It will flush older information out of the memory. In addition to the book Gail recommends,...