As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...
As a SQL Server administrator, you have a lot on your plate. There's server configuration, database design, performance tuning, troubleshooting, security and a host of other tasks all vying for your ...
At Tech-Ed 2011, Quest Software, Inc. announced a new version of its SQL diagnostics product, Spotlight on SQL Server Enterprise. The new release features integration with Project Lucy, a Quest ...
So we have (for example) 1,000 clients.<BR><BR>We collect lots of data from these clients and in turn provide detailed reports and key performance indicators for how they are doing compared to ...
OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...