Viewing 12 posts - 1 through 12 (of 12 total)
As an employee of a company that does exactly this sort of service (remote outsourced DBA) I can tell you the things you should be looking for are:
1.) A thorough...
July 8, 2014 at 6:53 pm
Optimise for ad-hoc is turned on on this server already - but there is still a lot of single use plans in the cache - presumably these have all been...
November 14, 2013 at 9:26 pm
Thanks Jonathan - I think on average I learn something new for every 5 words you write when you respond to something.
I don't know if that's purely you being a...
November 14, 2013 at 8:03 pm
Thanks for all the comments guys - after they applied CU6 a couple of days ago I'm seeing PLE consistently at 1.5 hours, the buffer pool is no longer using...
November 14, 2013 at 5:21 pm
Thanks guys - I had recommended that they apply the latest CU and I believe they applied CU6 last night. I'm on-site next at that client tomorrow so I'll check...
November 13, 2013 at 5:59 pm
Thanks for the feedback all - my first article so it's certainly a learning experience.
I haven't had a chance to play with 2014 yet - hopefully getting to that in...
September 19, 2013 at 5:11 am
Submitted - fingers crossed my first attempt at a public piece of writing passes muster.
September 4, 2013 at 7:50 pm
I have a routine I use regularly based on the DMVs to trace a blocking hierarchy which I'd be happy to share/explain.
September 4, 2013 at 6:35 pm
Neither of those DBCC commands clear the DMV's - the session you are connected with has still done x logical reads and y physical reads, regardless of what has or...
July 22, 2012 at 10:42 pm
Asking what to look at when a query is slow is a bit like asking what colour string to use to tie up a balloon - it highly depends on...
July 22, 2012 at 7:17 pm
You can completely ignore my post.
I just noticed that the script was setting the output variable FileName containing the file it found, and since my script wasn't working that wasn't...
July 8, 2012 at 8:17 pm
I'm a bit confused about a couple of things in this article.
Firstly, you've defined a FileName variable of BusinessData.YYYYMMDD.xlsx which is implying that a file can arrive with a datestamped...
July 8, 2012 at 8:09 pm