Performance Counters

Perfmon

Using PerfMon and PAL to Diagnose SQL Issues

Free tools to help you find and diagnose SQL issues

Excel Function Returns Cell Address

This article details an Excel 2010 function to return the cell address of min and max functions.

Top 14 KPI

Get the 14 most used Key Performance Indicators

Transaction Replication Latency Diagnosis

Identify resource bottlenecks in a stressed transaction replication topology using PERFMON/PAL and system wait stats

Working with Perfmon CSV logs in Powershell

When all you have is Powershell and perfmon logs, here's a way you can use them together to perform some analysis.

Paging Doctor Powershell

Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.

RE: PROBLEMS WITH SQL SERVER AGENT AND JOBS

 Hello, thanks for this message, I'd appreciate if anyone could tell me,  what kind of privileges does the windows account need, I mean the windows account that is defined foe the SQL SERVER AGENT,Thanks a lot,

RE: About Interview

For most companies, the HR interview is the first line of defense. The questions asked are typically used to determine the following:1) Your motivation for their position or your career path.2) Your ability to communicate ideas clearly3) How do you deal with abstract questions/thinking4) Do you appear to be a team player or loner.5) etc., etc., etc.Most […]