Tag Archives: Performance

Instrumentation

Posted on September 10, 2010 by way0utwest

In a discussion recently someone mentioned that they built in timing mechanisms into their application so they were aware of how long certain modules or functions were executing. Using this data, they could easily determine if the system was performing … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Instrumentation

Appliances – Just Add Data

Posted on September 3, 2010 by way0utwest

The first release of a large data appliance from Microsoft is the SQL Server 2008 R2 Parallel Data Warehouse Edition in which you buy a rack of pre-configured servers that you access with tools and perform limited management on. I … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Appliances – Just Add Data

The DBA Financial Analyst

Posted on August 25, 2010 by way0utwest

Will DBAs need to perform more complex financial analysis of the options they consider when building and tuning software systems? Steve Jones thinks it might be a skill needed in cloud computing. Continue reading →

Posted in Editorial | Tagged , , | Comments Off on The DBA Financial Analyst

SubQuery Performance

Posted on July 16, 2010 by way0utwest

Why would you do this? select distinct(hostname),(select count(*) as criticalCnt from @temp where severity_guid=’0168A833-1732-411E-8205-C2F6CD91737D’ and hostname=t.hostname group by hostname),(select count(*) as criticalCnt from @temp where severity_guid=’CB2F2B90-2DA4-4075-BCAA-DD5D2CEFBFD5′ and hostname=t.hostname group by hostname),(select count(*) as criticalCnt from @temp where severity_guid=’C4CF8A23-A106-4617-BAB0-94DA3CA74EF1′ and hostname=t.hostname … Continue reading →

Posted in Blog | Tagged , , | Comments Off on SubQuery Performance