Programming

Using Log Parser Studio To Find User Agents

Posted on

If you want to find out which user agents are used to visit your site, you can use the below query. You can use this to find out about browsers, and honest-ish robots (i.e. ones that identify themselves via the user agent). SELECT cs(User-Agent), count(cs(User-Agent)) as requestcount FROM ‘[LOGFILEPATH]’ WHERE date = ‘2016-08-02’ GROUP BY […]

Programming

Poking Around Services Using Commands

Posted on

Important Note! These commands for Windows Services work if you run Command Prompt as Administrator. List All Services SC QUERY state=all > “C:\Temp\Services.txt” This will drop a text file (because you’re likely to have more information than your command buffer) into the temp folder for your perusal. Start / Stop a Service Start a service… […]

Automation

Intermittent Replication Issue – Distribution Agent Failed to Create Temporary Files

Posted on

This will seem like a strange issue, because everything will work perfectly well for a period of time – but then it will all go wrong and you’ll get an error such as: Error messages: The distribution agent failed to create temporary files in ‘C:\Program Files\Microsoft SQL Server\110\COM’ directory. System returned errorcode 5. (Source: MSSQL_REPL, […]

Programming

Set Log Parser Studio Log Paths

Posted on

Log parser studio has a handy UI for adding log file paths, but if you have a shared hosting server with loads of IIS sites, each logging to a different directory – you’ll want to automate the list of log file paths. Go and find the file named “LPSFolders.tmp”, usually found in “C:\Users\USER-NAME\AppData\Roaming\ExLPT\Log Parser Studio\”. […]

Windows

Performance Data for this Service will not be Available

Posted on

Here is a pretty common piece of static interference you may find in your event log. It is commonly reported against the background intelligent transfer service: Application/Microsoft-Windows-Perflib The Open Procedure for service “BITS” in DLL “C:\Windows\System32\bitsperf.dll” failed. Performance data for this service will not be available. The first four bytes (DWORD) of the Data section […]

Windows

Live Server CPU Spikes

Posted on

We are monitoring a number of live servers, which we have grouped by role. This let’s use spot outlying servers pretty easily. The below graph shows the free CPU on one group of servers, with one obvious outlier. In our case, a quick glance at the box told us this wasn’t anything particularly suspicious – […]