James

Age: 36

Sysadmin (Windows, Linux) and DBA (SQL Server, MySQL).

5h
awarded Autobiographer
Oct
27
awarded Supporter
Oct
27
awarded Autobiographer
Oct
25
comment What are the dangers of non-IT managers using improper database terminology
It's a good question, just not a good question for this site.
Oct
12
comment How do I kill a rollback process when I want to drop the database?
I did something like that once and it turned out to be a Really Bad Idea. I'd rather just restart the instance than stomp on file handles and get potentially undefined behavior.
Oct
9
awarded Autobiographer
Oct
4
comment MySQL uses more than 500% of the CPU
The error message is about corrupt temporary tables due to filling up the MySQL tmpdir. I can't see any point in running a repair here.
Oct
1
awarded Civic Duty
Sep
30
comment Will increased network latency cause table locks in MS SQL Server?
Interesting results. What client program/library is this with?
Sep
30
awarded Supporter
Sep
30
awarded Explainer
Sep
29
comment why I can't delete old transaction log backup files with an existing scheduled job?
I'm not sure if I understand, but I think you need two maintenance plan cleanup tasks, 1 to delete transaction log backups (trn) and one to delete database backups (bak).
Sep
29
comment why I can't delete old transaction log backup files with an existing scheduled job?
In the maintenance plan, do you by any chance have the file extension to delete set to ".trn" instead of "trn"? If you include the period, it won't find any files to delete. This was a common annoyance with maintenance plans. Ola Hallengren's maintenance scripts are much easier to work with and generally more reliable.
Sep
28
revised Create failed for Availability Group 'AGN'
added 140 characters in body
Sep
28
answered Create failed for Availability Group 'AGN'
Sep
28
comment Create failed for Availability Group 'AGN'
Availability Groups only exist on SQL Server 2012 and up. I'm not sure why this is tagged with 2008.
Sep
28
comment How to get more information from dm_exec_query_stats
I'd suggest getting the value of last_execution_time from sys.dm_exec_query_stats. Then see what correlates with this in your website logs. You may need to enable logging of the query string (cs-uri-query) if it isn't already on. Searching the web server logs for the text that was injected probably won't work, as you found. One reason is that it might be encoded as hexadecimal.
Sep
28
comment MySQL Slave has unmanagbly higher IO load than master
I think your comment about seeks is probably looking in the right direction since random I/O is typically far slower than sequential. When I tested some SATA drives a few years ago, the maximum throughput for sustained 8 KB random writes on a 15k SATA RAID1 was under 5 MB/sec, and this was with the disks attached to a controller that had a write cache enabled, and on smaller disks that probably had a lower average seek time than the ones you're using.
Sep
28
awarded Supporter
Sep
28
awarded Autobiographer
1 2 3 4 5