Adapting SQLDiag to your needs

Often times, our team is confronted with SQL Server performance issues and in most of those times, the issues are due to locking and blocking in heavily loaded scenarios. As such, our typical approach consists in gathering a SQL Server Profiler trace while running a script which periodically polls the database for blocked SPIDs. The…

0

A Simply but Great Visual Network Tool to Improve Web Site Performance and Best Practices

A few days ago, I needed to analyze and profile a start page of a web site. My main concern was performance (time to get all the page, network issues, unnecessary round trips, unnecessary bytes, …). My first question: Which tool can help me? I found a lot of network tools, and I started out…

1

PAL – Performance Analysis of Logs

Keeping track of your infrastructure’s health can easily become a big challenge. More and more applications mean more machines, different requirements and a lot more places to look for when your users call you complaining that something is wrong. One of the places you’ve probably looked for answers (or were advised to) was the Performance…

3

Are you a terminating process? Then please pay the toll…

  Recently, I had the chance to participate in a performance review of a Line of Business application which dynamically creates portable document files (PDF, in short) which are then sent to the web user over the wire. The process of PDF creation has several steps which include some database querying, some file system operations…

0