rottengeek

well, we're on the same team. The DBA is on the Infrastructure team, here. (Kinda fun, really!) We had an issue with the tool not deleting the snapshots a few nights ago, and a system went down. It happens a little too frequently. And all the added I/o across the infrastructure, as well as disk space consumed, actually has…

I used it for years and found DPA to be an EXCELLENT tool to get across points quickly to management and developers regarding change and to troubleshoot queries. It makes it really easy to track the worst performing queries. You also get the wait stats, reads, writes...I've used it for years and found it to be very useful.…

yes, i have to admit that i have a really self-absorbed ability to ignore anything that doesn't have to do with what expressly concerns me at the moment. I'm starting to get hungry, though, and the pictures are complicating things. Being as the entire world is virtual, I'm trying to imagine my VMs on fire, along with the…

hmmm...after careful data dredging and highly skilled linguistics analysis, in-depth review of the etymology of "chunkin' " reveals that...wait for it... it rhymes better with "Pumpkin" than "chuckin' "

I have a question which, for some reason, I'm having a VERY difficult time articulating an answer to. Here is my situation: I finally convinced my company not to do VM backups, Commvault backups and SAN snapshots of my SQL Servers. (I thought!) We have the 2 production clusters for the applications which are required to be…

I totally want to try this with blades in the cannons, now. Who am I kidding? I want to try this in my backyard.

Yep, that's it. Update for Case #908387 - "I need to pull details on batch requests per second but can't find it in the database" I'll update the ticket. Basically, it is the same for both. What do you base "active sessions" on? Running and runnable?

SQL Server 2012, for both. We also get spikes of batch requests during the day, they, too get leveled on a day-long graph.

thanks so much. It makes sense, really.

sorry it took so long to reply - but, yes. Instances which are not being monitored have the trace, and the system_health trace is not capturing the deadlock graph - which means it is kind of a pain to get good deadlock information.

no, actually - it is really kind of odd. The Resrouces tab, which shows all the graphs, is no longer showing the SQL graphs I had added. In fact, the only graphs it shows are VM related (and I'm not on the VM tab, I'm on the performance tab) It is allowing me to put them back in, I just thought it was odd and decided to…