I’m happy to report that some progress has been made on my performance problem. I’m still working on it, and there will be a full progress report to come, but for now I’m simply happy to say I’ve gotten somewhere in the EXECSYNC dept. Now, that’s not to say I’ve gotten rid of them, but […]
Ever have one of those days when you feel like you know absolutely nothing? That pretty much sums up the past week for me. I’ve been fighting with a performance problem and have come up empty on all fronts. WTF? We’re in the middle of a project to upgrade one of our financial databases. The […]
This morning, I was trying to restore a database from a SQL 2005 backup to a new server. The restore involved a full backup and a differential. I restored the full backup with NORECOVERY via SSMS, but when I tried to restore the differential, also via SSMS, I got this error: Okaaay. I was a […]
I want to stick with the subject of memory because I think it’s probably the most misunderstood (and sometimes downright mysterious) component of SQL Server. I know I, for one, could benefit from a better understanding of its inner workings. So today I’d like to share that little bit of code I mentioned last week, […]
My research into the Resource Governor question and its answer brought up another question for me: Where does that total_memory_kb number for the default pool actually come from? After all, I have a max server memory of 26000MB for the instance, so why 18175MB? The BOL description for this field wasn’t very helpful. Googling for […]
