DaveWentzel.com            All Things Data

March 2011

Profiler and Tracing Performance

Yes, running sqltrace/Profiler can actually cause performance issues on your server.  Some little known facts about Profiler and sqltrace:

  • if your trace data queues up you will see server throughput drop.  Look for waits of IO_COMPLETION, TRACEWRITE, and SQLTRACE_LOCK.  You are probably monitoring too many events.  
  • When you trace using sp_trace_* you are using the file provider.  When you trace with Profiler it is a rowset provider.  The file provider is basically lossless so if you are capturing a lot of data you will queue up and cause waits.  The rowset provider is less restrictive which is why you will sometimes see the message "Some trace events have not been reported to SQL Profiler because the server has reached its maximum amount of available memory for the process."
  • Be careful using "Server processes trace data" option.  From BOL:

Specify that the server running the trace should process the trace data. Using this option reduces the performance overhead incurred by tracing.

Well, that's not quite right in my opinion.  If you enable that option and start your trace and then SELECT * FROM sys.traces you'll see you've actually started two traces!!!

Note here that one is a rowset provider (the GUI) and one is a file provider.  

  • Watch for 3rd party tools that run traces under-the-covers (Spotlight and Foglight for instance).  You may be running traces you weren't even aware of.  
  • Don't think that just because you are limiting the amount of data written to a file (or output to the screen) that your trace is somehow more lightweight.  The event must still be captured in the event sink, with all of its possible data columns, then the filter is applied and only necessary data cols are output.  

Profiler Tips



Some Tax Basics For IT Consultants

Previous Posts
Independent Consulting - the setup

After I decided that I wanted to be a freelance IT consultant I needed to determine what type of entity to setup.  Before doing that it's important to understand some tax basics that most career W-2 employees probably do not know.  As with all of these posts, I am neither a tax attorney nor accountant, please seek professional advice before attempting any of this on your own.  

Independent Consulting - the setup

For a few months now I've been contemplating quitting my day job to be an independent database consultant.  I finally took the plunge a few months ago, landing a large client doing some advanced data architecture work.  So far I'm very happy.  In fact it looks like I may be landing some additional contracts, including one with a former employer.  What I found most fascinating is the process of setting myself up as an independent entity.  I was given the option of working W2 for an outsourcer, 1099, or corp-to-corp.  I was given this same opportunity a decade ago and went the safe and simple W2 route.  I had to make the decision this time quickly and I knew from collegues that C2C was the most lucrative, if you want to be a little more proactive in your finances.  I chose the C2C route this time and am learning the intricacies of how you have to set yourself up to maximize your income in this arrangement.  Corp-to-Corp is by far the most complicated arrangement but you should be able to defer tax on a larger portion of your income. These notes are mostly for me to remember how I have things set up, but maybe someone else can use them.  In no way am I advocating that this is the proper setup for anyone else.  This is not tax or legal advice.  

In these few blog posts I'm not going to cover marketing, the benefits of hanging out your own shingle, how to collect payment, etc.  I'm solely going to focus on the tax ramifications of being an independent consultant.  Why?  It seemed very confusing to me while I read various web pages, books, magazine articles, etc, until I realized there are a few basics to understand and each reference I used assumed a certain setup that may or may not be applicable.  Once you have the basics you can dive into the complex topics without confusion.  


I'm not a tax-expert, lawyer, or anything like that so if you use my notes as a guide to set yourself up similarly, you're crazy.  Do your own research and consult with experts.  Since I have no desire to hire additional employees (other than my wife and kids, discussed later), I'm just a simple freelancer, my situation seemed to be very simple.  It was important to my client that they only sign deals with an "entity" to ensure that later I'm not reclassified as an employee.  The easiest thing to do is setup an LLC (limited liability company).   Your clients do not need to file a 1099 if you are incorporated (or have an LLC) and your client contracts with the corporation and not you personally.  Make sure your client knows that this is in his best interest since the IRS flags companies that file "excessive" 1099s as trying to misclassify employees as independent contractors.  

First, it's helpful to understand some tax basics.  Without a decent grounding of tax issues you won't fully understand if an LLC, S Corp, or "LLC taxed as an S Corp" is the right choice for you.  To keep you from dying of anticipation the best entity for an independent IT consultant seems to be an LLC taxed as an S Corp.  

Other Posts in this Series

nodetitle...covers a few of the methods you can use to organize your business.  

Next Post...Some Tax Basics...handles some tax terms you probably were not aware of if you have always been a W-2 employee.

Tax Procedures...covers how taxing works mechanically for the self-employed organized as an S Corp

Business Expenses...covers various business expenses an independent IT consultant can expect.  

Home Office Deduction...don't fear it, it is your friend when you fully understand it.  

Health Insurance Premiums...how to handle these effectively as an S Corp

Life Insurance Premiums...how to handle these most effectively as a business owner.  

Hiring Your Family...if you pay your kids an allowance here is an interesting method to save some tax dollars in the process

SIMPLE IRAs...and how they can really help you maximize your tax situation.  

Independent Consulting Summary...summarizes everything I have learned so far.  

Terminal Services Learnings

After being stuck using XP to connect to old Win2003 servers I never noticed the newer "features" of Terminal Services/mstsc.  Lately I've been annoyed by the fact that the 3rd "hidden" console connection in terminal services appears to not be available in new OSs.  When you try to connect using mstsc with /console it appears as though the /console is just ignored.  And in fact, that is exactly what occurs.  Instead you should use /admin.