Users are still reporting slowness. I reset the wait stats yesterday so I could get a better picture of what is going on after the changes. Below is the current...

Things are looking much better. Obviously SQL didn't have enough memory to function very well. I guess the thing that bewilders me is that Memory Grants Pending and those sort...

Thanks, Gail. We found Windows Updates choking a bunch of RAM on that box. It looks like it was hung. This has been cleared, and we rebooted the box. Things...

Thanks very much, Grant. I'm so new to the admin side that its hard to know where to start. But one name I always recognize is Paul's. I was actually...

Perfect, thanks a ton!

Great, thanks for the tip!

Haha that's what I love about this place - loads of different ways to do the same thing. I really appreciate all of this input. It really helps with my...

Yes, it is sourced from the SAN. Thank you for the link. I will check it out.

Thanks again. One more question if that's okay. Our current setup drive setup is as follows:

C: - SQL installation
D: - Data files (MDF and NDF)
S: -...

Thanks, Alan. I'm working through the link and noticed the MSDN article states Microsoft recommends using a Virtual account for the Database Engine and the Agent. Why do you prefer...

Okay, thanks Steve and Chris. That was going to be my next question - What you all recommend for monitoring that.