3,860 reputation
817
bio website brentozar.com
location Chicago, IL
age 40
visits member for 5 years, 2 months
seen Jun 12 at 17:06

I make SQL Servers faster and more reliable. I'm a Microsoft Certified Master and Microsoft MVP.

Stuff I'm proud of:


Mar
16
comment How do I get SQL Server to release its memory?
@Massimo Can you point to some documentation on that?
Aug
13
comment Help me make sense:VLAN, Hyper-V, Intel VMLB
Make sure you install the Intel drivers. The default ones from Microsoft don't include VLAN tagging as a config option.
Feb
23
comment Query Performance Degrades with High Number of Logical Reads
Yep, depending on how SQL Server and the T-SQL statement works, even dynamic SQL can get a cached plan.
Feb
18
comment HA suggestions for geographically separated sites
And yeah, that mirroring connection string trick comes in handy, heh.
Feb
18
comment HA suggestions for geographically separated sites
OK, if it's more important to have availability than have it intact, I'd go the bidirectional replication route, but just know that there are a lot of ways it can break. Fortunately, it usually breaks "up" - both sides still accept reads & writes while it's broken, but the changes just aren't making it to the other node.
Feb
17
comment What is the standard method to keep track of the latest Cumulative updates for SQL Server?
Wow, that's nice. And to know when it changes, you can use WatchThatPage.com. It's got a crappy UI, but it works.
Feb
16
comment HA suggestions for geographically separated sites
Allan - why wouldn't replication combined with a geographic load balancer (like an F5 Big-IP) work? Clients connect to a DNS name that points to the Big-IP, and that device automatically routes them to whatever server is up. That's totally transparent to the clients.
Feb
16
comment HA suggestions for geographically separated sites
@Blootac - just to be clear, you're saying you can't tolerate 2ms of query slowdown, but you can tolerate 5 minutes of data loss? That seems a little odd, but in that case, log shipping is probably the easiest solution. Set up the client's connection strings to use the database mirroring failover partner option, and they'll automatically try to connect to the secondary server. You'll need to script something to do a RESTORE WITH RECOVERY on the secondary server if the primary has been down more than a couple of minutes.
Oct
22
comment Verify SQL Server Mirroring failover is successful
Thanks, glad you like the blog! Yes, if you want automatic failover, mirroring is the only game in town. You can use high performance mode for mirroring, which doesn't commit transactions on both servers simultaneously and doesn't allow for automatic failover, but then human beings have to get involved when there's a server failure.
Oct
18
comment Boost SQL Server priority: should it be used?
Agreed. I've also seen cases where SQL Server's priority has exceeded the hardware manufacturer's driver priority, and the drivers haven't been able to get the CPU time they need to keep up with SQL Server. Caused a bluescreen at StackOverflow, believe it or not.
Oct
18
comment Implementing dual control SQL updates in SQL Server
+1 - there's nothing in SQL Server that will do this.
Oct
8
comment CREATE DATABASE equivilant of RESTORE DATABASE WITH REPLACE
I hear ya, but not everybody runs SQL Server as a limited access user and sets filesystem permissions correctly.
Aug
10
comment Sysobjects issue in sql 2000
No problem! If it's the right answer, hit the Accept Answer thing here so it'll close the question. Thanks!
May
28
comment Best Information Technology Blogs
thanks, sir!
May
16
comment Is it OK to run perfmon on production servers? And why?
Ah, cool! Let me know what you think of it.
May
12
comment Is it OK to run perfmon on production servers? And why?
Agreed - there's no overhead from running Perfmon. Another answer suggested running Profiler instead of Perfmon, but there is a very real overhead to running Profiler. I've seen Profiler traces take down production servers when the tracing box couldn't keep up with the load, or when the added load pushed the production server over the edge.
Feb
19
comment Recommended settings for 2-tier server environment
Thanks, glad you liked it!
Feb
5
comment Performance monitoring from guest OS
Wow, nice find! I gotta go play with that.
Feb
1
comment How do I get SQL Server to release its memory?
VMware's balloon driver does exactly this - it asks Windows for more and more memory in order to get SQL Server (or any other application) to give up their memory.
Jan
29
comment SQL Server 2005 64bit on 16GB machine uses 3.6GB memory only
The part about "it will retain that forever" is not true on virtual servers. On VMware (like this question), there's a balloon driver running inside the OS that will periodically request more memory, faking OS memory pressure, in order to get other apps to let go of memory. This helps virtual machines share memory better, but it hurts SQL performance. Just an FYI.