3,870 reputation
817
bio website brentozar.com
location Chicago, IL
age 40
visits member for 5 years, 5 months
seen Sep 17 at 14:44

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

Stuff I'm proud of:


Feb
11
answered Recommended settings for 2-tier server environment
Feb
5
comment Performance monitoring from guest OS
Wow, nice find! I gotta go play with that.
Feb
2
answered Performance monitoring from guest OS
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.
Jan
29
comment Optimum implementation of new SQL/IIS setup?
Another advantage of splitting IIS and SQL is licensing - you can scale the web VM up to more processors without paying more SQL Server licensing.
Jan
28
comment 1 logical drive vs 2 logical drivers on 1 raid controller to separate data from log files?
@mrdenny means RAID 10 gives you 50% of the disks for reading. We can split hairs about that one - RAID 5 is better for one person reading, RAID 10 can be better for multiple simultaneous reads. Either one is a good choice for mostly SELECTs though. @sfonck - no, that's not as good as creating another logical drive. In theory it is, but here's the reality: sooner or later, someone (maybe you) is going to add another database and they're going to forget about setting a limit on the log file growth. Or, all of the log files will grow simultaneously and they'll add up to fill up the drive.
Jan
27
answered 1 logical drive vs 2 logical drivers on 1 raid controller to separate data from log files?
Jan
25
comment Best practice for sql server - setting up auditing for actions on a busy website
Cool, glad I could help!
Jan
23
answered VMware Fusion: transfer programs/config from one Windows to another
Jan
23
comment Disk controller speed responsible for slow write speeds?
If you've got another similar box handy, you can also gauge the raw speed tests before using VMware with SQLIO. It's a free utility from Microsoft. Always, always, always benchmark your storage before you go installing things. sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO
Jan
23
comment VM Ware Pricing Confusion
He's right about re-licensing the vCenter server.
Jan
23
answered Best practice for sql server - setting up auditing for actions on a busy website
Jan
12
comment PhpMyAdmin for Sql Server
No, that's something you have to add - it's pretty similar to phpMyAdmin.
Dec
14
awarded  Nice Answer
Dec
6
awarded  Mortarboard
Nov
13
comment SQL Server 0x0004005 “Unspecified error”
That's a side effect. That particular error number is like the "junk drawer" of SQL Server - all kinds of stuff can trigger it.
Nov
13
answered How long does reindexing take on SQL Server?
Nov
13
comment Is it possible to add more hard disks to RAID10 while keeping it online?
In raid 10, you add capacity with pairs of drives at a time.
Nov
13
comment Is it possible to add more hard disks to RAID10 while keeping it online?
It depends on the RAID card you're using - can you add that to the question description? The 1950 can come with a few different cards, and the exact steps will vary on the card.