Archive | Performance RSS feed for this section

Linked Server Query Running Slow?

by Mike Walsh on 08. Jul, 2010 in Best Practices, Performance, Syndicate, T-SQL

Is your SQL Server Linked Server Query running slow? Check your permissions. Maybe this is old news to you but it wasn’t for me –>
It was a good day. We had finally migrated onto brand new hardware (and saw a 250% improvement in run times of most warehouse jobs). I had finally cleaned up the [...]

  • Share/Bookmark
Read full story • Comments { 4 }
reports_file_database_thumb[7]

T-SQL Tuesday #005 – Reporting For Duty

by Mike Walsh on 13. Apr, 2010 in #tsqltuesday, DBA, Performance, Pet Peeve

Aaron Nelson is hosting this week’s T-SQL Tuesday. His topic, like mine from last week, has a lot of ways I could go. He basically said to talk about something that has to do with reporting. I decided to take the hodgepodge approach and talk about a couple things.
Disclaimer  – I am not syndicating this [...]

  • Share/Bookmark
Read full story • Comments { 2 }
ScreenShot007

You Could Be Suffering Right Now

by Mike Walsh on 01. Sep, 2009 in Best Practices, Performance, Syndicate

Implicit Conversions In SQL Server – A Silent Perf Killer
I recently had the opportunity to work with a developer at the day job. He was using a loop (for what he was doing it actually makes sense ) and he had a query that ran great when he stripped the query out of [...]

  • Share/Bookmark
Read full story • Comments { 0 }
Perfmon-Counter-Description

Benchmarking… Who Needs It?

by Mike Walsh on 07. Aug, 2009 in DBA, Performance, Pet Peeve, Syndicate

All of our SQL Server instances need benchmarks!
So the title is somewhat of a trick question… I hear and sense a lack of priority around taking periodic benchmarks in a system with a lot of folks. How often do you take benchmarks? Do you know what “normal” means for your system? Do you know when [...]

  • Share/Bookmark
Read full story • Comments { 1 }
Older Entries »