1,553 reputation
614
bio website paulkroon.com
location Glenside, PA
age 29
visits member for 4 years, 11 months
seen 11 hours ago

I'm a sysadmin for a Windows environment (MCSE: Security) with a few Linux boxes as well, which includes handling the whole list of things that come up in an office. If it uses electricity, I pretty much support it. My areas of "expertise" would be VMWare Infrastructure, Exchange 2010, SQL Server 2005/2008, PHP programming, and scripting of all kinds (VBS, Bash, Perl).


Feb
21
comment DNS Setting keeps changing on me
Assuming I'm correct in your problem, that won't change it back to the IP you want, it will only prevent Windows from registering the IP again. You would need to change the record to what you want manually, and then Windows should not try and register it again.
Feb
21
answered DNS Setting keeps changing on me
Feb
14
answered SMS Gateway Suggestions Needed
Feb
9
accepted Unusual CPU usage on SQL 2005 Mirror
Feb
9
comment Unusual CPU usage on SQL 2005 Mirror
Thanks for the counters, there were some I wasn't using. I watched both the mirror and the principal, and found the same increase in activity, so I ruled out the mirror. However, there were no jobs running that corresponded with the spikes. But, this did make me realize that there were jobs on other servers that also used this database, and I manged to find a heavy-hitter that ran at the 10 minute intervals. Thanks for the help!
Feb
9
comment Unusual CPU usage on SQL 2005 Mirror
My first thought was a job, but the only ones that would match up run at 1 and 15 minute intervals, so I should see it more often. I've looked at a few counters, and I can see Transactions/sec go up during that time, but do you have any particular counters in mind that would help see exactly what might be running?
Feb
9
asked Unusual CPU usage on SQL 2005 Mirror
Feb
8
awarded  Yearling
Feb
1
comment Dell SSD options and 3rd party SSDs in Dell hardware
This seems to be beyond what you're looking for, but probably interesting to note. We just put this in an D910 to run an MSSQL server: fusionio.com/products/iodrive.
Jan
31
comment SQL Server - VMWare install - Utilize more RAM
What are the specs on the ESXi host, and how many other VMs are running on it (how many vCPUs)? Also, what are the min and max memory settings set to on the SQL server?
Jan
29
comment Alternatives to DNS round robin
xzyfer does mention using a LAMP stack, which means he's running Linux (and Apache, MySQL, and PHP). The problem with DNS round robin is that there is too much of a delay for it to work for failover. It could be hours, days, or weeks before a client sees the new server because even though you can specify a TTL, clients don't have to respect it. It is a pretty cheap and effective method of load balancing (although there are obviously much better methods), but it sounds like xzyfer needs instant failover, not load balancing.
Jan
29
comment Alternatives to DNS round robin
This isn't related to your main question, but your read-only fs is likely caused by VMWare disk issues. I don't know what your VMWare infrastructure is, but we run VMWare ESX servers with shared SAN storage, and issues with the LUNs (even a small interruption) will cause this on Linux VMs. Depending on your infrastructure, you might even want to consider VMWare Fault Tolerance as a solution to your main question (communities.vmware.com/community/vmtn/vsphere/…).
Jan
28
comment What is the difference between SAN Hard Drives and Normal Hard Drives?
Having run both SAN systems and our own disk arrays with drives bought from NewEgg, I'd want to add that there is definitely a noticeable difference in quality of the drives. Standard drives bought from normal retail stores are not meant for the typical 24x7 workloads in enterprise systems. That's not to say the cheaper drives don't have their place, but you definitely get what you pay for and will need the higher quality drives for 24x7, high performance operations.
Jan
26
comment Using SQL Profiler on a database that's in production
I agree with gbn, it definitely requires resources, so you'll need to be careful when running it. We typically use it with a filter on the login to debug the action(s) of a particular user for a specific problem. We also periodically run a trace for the whole day to gather information. Something like this definitely needs to be scheduled on days with lighter loads, and needs to be very closely watched. It also helps the load to log to local files on another computer and then process the data afterwards.
Jan
4
comment Migrating Windows Server 2003 installation to new hardware
You could probably just use a trial to get this done quickly: acronis.com/enterprise/download
Jan
4
answered Migrating Windows Server 2003 installation to new hardware
Dec
11
answered Exclude email address/recipient from Exchange 2010 dynamic distribution group
Nov
26
comment Windows Server 2003 - Give User Full Admin Privileges
What is your goal in giving these users additional access? Do they need to be able to do something in particular? For whatever they need, do they need to have this access across your entire domain (all servers and workstations), or just on this single domain controller?
Nov
23
answered Windows Server 2003 - Give User Full Admin Privileges
Nov
8
answered recommendations for efficient offsite remote backup solution of vm's