931 reputation
1820
bio website
location London, United Kingdom
age 36
visits member for 2 years, 7 months
seen 2 hours ago

SQL Server DBA/developer


6h
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
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  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
27
comment Moved database (percona mysql) to larger disk, now everything is missing (though the files exist)
They shouldn't be empty if MySQL is starting. Can you log into MySQL? Does SHOW VARIABLES LIKE 'log_error' point to the name of an empty file? Do you get any error output if you try to restart MySQL?
Sep
27
comment Moved database (percona mysql) to larger disk, now everything is missing (though the files exist)
To start with, I'd suggest looking in the error log and then updating your question. The error log will most likely be in either /var/log/mysql or /var/lib/mysql.
Sep
27
comment Backup the whole SQL Server databases in one .bak file - SQL Server 2005
How will one backup file help you? Even if you have all 200 database backups in one file, you'll still need to write 200 restore statements.
Sep
24
revised MySQL Slave has unmanagbly higher IO load than master
deleted 94 characters in body
Sep
24
comment MySQL Slave has unmanagbly higher IO load than master
Interesting, I didn't know about RAID1E which I guess is what that is. Figuring things out is why I suggested I/O benchmarking; you may find that one I/O subsystem is much slower or faster than you expect. Brendan Gregg also has a Linux performance troubleshooting checklist here that you might have already seen. You can look into this very deeply with some of the tools listed there. But really, I wouldn't consider the problem mysterious or surprising if the two servers are mismatched.
Sep
24
answered MySQL Slave has unmanagbly higher IO load than master
Sep
22
comment How to make sqlcmd return an ERRORLEVEL other than 0 when the .sql script fails?
For what it's worth, at my current job, we use Ola Hallengren's backup stored procedures (with some in-house wrapper stored procedures around them) to backup thousands of databases across hundreds of servers, and we've had no problems with them.