|
|
|
|
Browse by Tags
All Tags » performance (RSS)
-
This month’s T-SQL Tuesday – a blog party dreamed up by sqlblog.com’s Adam Machanic ( blog | @ AdamMachanic ) – is about that code we’ve all written that we don’t really like to think about too often. You know the stuff. I can’t help but imagine the next Read More...
|
-
This is the third installment of a series on our deployment of System Center at my workplace, emphasis on SQL Server MP. At this point we’ve got Operations Manager installed, and up and running, and we’ve been able to categorize all the monitored servers Read More...
|
-
I was fortunate to be able to attend the Vancouver BC SQLSaturday this past weekend, and it was excellent! Great sessions, good facility, well attended. Nice work, and a huge thank you to the volunteers that made that happen. One side perk: I got a copy Read More...
|
-
At my office we’re about 90 days into our implementation of System Center Operations Manager for Windows Server and SQL Server monitoring. All in all it’s been a good experience, and I’m really excited to have access to this tool. I’ve logged a fair number Read More...
|
-
A contribution for T-SQL Tuesday #004 , hosted by the illustrious Mike Walsh! In the past few weeks I had some correspondence with Kendal Van Dyke leading up to his SQL Saturday presentation on SSDs, and he got me fired up to share a little of my team’s Read More...
|
-
As will become apparent from this post, I am no Storage Admin. My apologies for offending the sensibilities of those who know this topic better than I do! I get asked occasionally about placing SQL Server data on SAN storage, and I've done it with a few Read More...
|
-
To all who are SQL savvy, this is old news, but I wanted to put this tidbit up for you to pass along, as a concise proof, to others that might subscribe to this performance myth. On forums and Stack Overflow, it seems I constantly see this misinformation Read More...
|
-
Common wisdom with previous generations of server hardware was that SQL Server might not benefit from hyperthreading or could be degraded at high CPU usage; does anyone have definitive data about Nehalem (non-EX) servers and SQL Server 2005 or 2008? Here Read More...
|
-
Partitioning for Fun and Profit Over the past year or so I’ve been playing with a toy SQL monitoring application, just to sharpen my dev skills a bit. Part of the app is a SQL database to store historical performance data, in order to do trending. Fooling Read More...
|
-
So, found this incredible freeware program on Codeplex with a really simple UI to handle performance optimization for SQL Server: I was gonna post the link here but I lost it, and now the site seems to have been taken down... OK, I am obviously lying. Read More...
|
-
Spoiler: TPH is an evil trap In the last installment I pleaded for the equal treatment of the database schema and object model when implementing an application with a database, on the grounds that the failure of either means the failure of the whole system. Read More...
|
-
This is the third part of a series ( Part 1 , Part 2 ) thinking out loud about the decision making around data access for applications. Once you've considered how tightly bound your application code can safely be to tables, I would like to put two related Read More...
|
-
Lately I'm faced with a fairly ambitious data center move, and at the same time with an initiative to consolidate sprawling SQL Servers onto centralized clusters. It's a chunk of work, but these two notions have fit together pretty well: as long as we're Read More...
|
-
I'd like to pass along a couple of tips for those new to using SAN storage for SQL Server. SAN Storage is quite expensive, and doubly so if your storage doesn't deliver on the performance front. SAN disk arrays are not magic, and sadly they don't just Read More...
|
|
|
|
|
|