5/03/2013
Monitor for blockings...
Short and sweet...
Ticket for error 1105. Teammate response: No blockings on server, monitor 4 days.
Ticket for error 601. Teammate response: No blockings on server, monitor 4 days.
Ticket for login failed. Teammate response: No blockings on server, monitor 4 days.
I. Kid. You. Not.
Someone needs to be fired. Or congratulated for making me look like a SQL SERVER GENIUS!!!! by comparison.
That is all.
Kevin3NF
Ticket for error 1105. Teammate response: No blockings on server, monitor 4 days.
Ticket for error 601. Teammate response: No blockings on server, monitor 4 days.
Ticket for login failed. Teammate response: No blockings on server, monitor 4 days.
I. Kid. You. Not.
Someone needs to be fired. Or congratulated for making me look like a SQL SERVER GENIUS!!!! by comparison.
That is all.
Kevin3NF
6/07/2011
Wow...its been a long time since something went so sideways I felt compelled to write about it....
But don't mistake that for there not being any craziness!
ATTENTION ALL DEVELOPERS!!!!
If you are going to do a major upgrade to your very large database, please consider the following:
Not only do you not get fries, you now owe me some! (Waffle fries from Chick-Fil-A will be just fine, thanks.)
That is all.
But don't mistake that for there not being any craziness!
ATTENTION ALL DEVELOPERS!!!!
If you are going to do a major upgrade to your very large database, please consider the following:
- YOU are responsible for your rollback plan. Nobody else.
- When you wake us up to rollback because your upgrade blew up, please give us a chance to get up to speed, before you start calling Directors and VPs.
- TAKE A BACKUP IMMEDIATELY BEFORE THE UPGRADE!!!!!
- Store that backup in a folder that does not have a cleanup/delete process attached to it
- Test this upgrade in your test/dev environment first.
- Don't expect me to throw a teammate under the bus on a conference call.
- Don't expect me to be on a conf call every 30 minutes...I'm busy cleaning this up.
Not only do you not get fries, you now owe me some! (Waffle fries from Chick-Fil-A will be just fine, thanks.)
That is all.
4/15/2009
OK...if all 3 instances on a 3-node cluster suddenly start "timing out", yet you can log directly in and query the databases...don't you think you should at least look at the network components first?
Especially when the errors are showing on the client and web boxen...
Grrrrr....
Especially when the errors are showing on the client and web boxen...
Grrrrr....
3/11/2009
When to Modify Somebody Else’s Code
I was tagged by Brent Ozar on this question that has been floating aroung the Tweeterverse and blogosphere the last few days...
In keeping with the short-but-useful-or-amusing style of this blog:
When you have an OK in writing from the vendor or internal group that wrote it AND from the supervisor you got the approval from on your side.
Yeah...make darn sure your suggestion actually works before you even ask, do backups, keep scripts, etc.
Else you get no fries. You get fried. :)
Kevin3NF
Tag: Lee Everest
I was tagged by Brent Ozar on this question that has been floating aroung the Tweeterverse and blogosphere the last few days...
In keeping with the short-but-useful-or-amusing style of this blog:
When you have an OK in writing from the vendor or internal group that wrote it AND from the supervisor you got the approval from on your side.
Yeah...make darn sure your suggestion actually works before you even ask, do backups, keep scripts, etc.
Else you get no fries. You get fried. :)
Kevin3NF
Tag: Lee Everest
Labels: vendor code modify
1/29/2009
You did what?
This one comes from inside....
We got an alert that the Log Shipping was out of sync for a customer. Our front-line guy looked and saw that the LS Restore job was still running after 35 minutes when it normally takes less than 30 seconds.
He decided it was hung and cancelled it. Restarting the job caused immediate errors.
Why? The restore was working on a 1.4 gb t-log backup file, instead of the normal 4-5mb. Cancelling it puts the database in a suspect state. had to drop the db and re-initialize from a full database backup.
Ugh. Glad it wasn't any bigger than 7gb...since the file/restore had to move halfway across the country.
No fries for you "M from M"...you owe me some!
Disclaimer: this is a pretty sharp guy and I'm just harassing him here...
Kevin3NF
This one comes from inside....
We got an alert that the Log Shipping was out of sync for a customer. Our front-line guy looked and saw that the LS Restore job was still running after 35 minutes when it normally takes less than 30 seconds.
He decided it was hung and cancelled it. Restarting the job caused immediate errors.
Why? The restore was working on a 1.4 gb t-log backup file, instead of the normal 4-5mb. Cancelling it puts the database in a suspect state. had to drop the db and re-initialize from a full database backup.
Ugh. Glad it wasn't any bigger than 7gb...since the file/restore had to move halfway across the country.
No fries for you "M from M"...you owe me some!
Disclaimer: this is a pretty sharp guy and I'm just harassing him here...
Kevin3NF
Labels: sql 2005 log shipping suspect
1/15/2009
North Texas SQL Server User group
I live, work and play in the DFW area and used to be a regular attendee at the local user group monthly meeting. I was even a board member. The topics became increasingly over my head or out of my area of daily need, so I started slacking and eventually quit going altogether.
No more!
Tonight I start the first of 5 or 6 months of free Power Shell beginner classes that happen before the SSUG meeting starts, taught by a local expert. I don't even know what Power Shell is...some sort of scripting language is all I gather.
In addition, my co-worker Trevor Barkhouse is the presenter this evening. He will cover "Refactoring T-SQL Code for Better Performance". I've seen him do this here in the office to help a couple of our problem customers resolve nagging issues that were frustrating them.
More about NTSSUG
Kevin3NF
I live, work and play in the DFW area and used to be a regular attendee at the local user group monthly meeting. I was even a board member. The topics became increasingly over my head or out of my area of daily need, so I started slacking and eventually quit going altogether.
No more!
Tonight I start the first of 5 or 6 months of free Power Shell beginner classes that happen before the SSUG meeting starts, taught by a local expert. I don't even know what Power Shell is...some sort of scripting language is all I gather.
In addition, my co-worker Trevor Barkhouse is the presenter this evening. He will cover "Refactoring T-SQL Code for Better Performance". I've seen him do this here in the office to help a couple of our problem customers resolve nagging issues that were frustrating them.
More about NTSSUG
Kevin3NF
12/16/2008
A series of conversations from several days...compacted into one nightmare. Enjoy:
Front line dude: Acme has a drive space issue...can I shrink the log file?
Kevin3NF: Give it a shot (this is SOP for Acme on this drive)
FLD: Didn't work
Kevin3NF: Give me the ticket, I'll take a look.
Kevin3NF: Hey ACME developer...you have a 2 day old transaction taking up all your T-log space...
Acme: ok...let me truncate the log
Kevin3NF: WAIT A SECOND!
Acme: Did that help?
Kevin3NF: No. You just invalidated the T-log backup stream and started causing the backup to fail
Acme: Why?
Kevin3NF: Cuz that big open transaction is still there, and SQL Server thinks there is no full backup now.
Kevin3NF: Hello?
Kevin3NF: (Sees pictures of crickets in his Inbox)
Acme: (hours later): go ahead and run a full backup tomorrow afternoon
Kevin3NF: You know you don't have a valid backup to recover to, right?
Acme: Yes, but we can't backup now...
(tomorrow afternoon):
Acme: Hey...who told you to run a full backup?!?!?
Kevin3NF: You did...I have the email.
Acme: (complaint to Kevin3NF's bosses)
Time passes...repeat scenario.
Big transaction, full log file, fill drive, lather, rinse, repeat.
Customer: FAIL. >:(
Acme me owes ME some fries...but I get paid to deal with stuff like this every day :)
Kevin3NF
Front line dude: Acme has a drive space issue...can I shrink the log file?
Kevin3NF: Give it a shot (this is SOP for Acme on this drive)
FLD: Didn't work
Kevin3NF: Give me the ticket, I'll take a look.
Kevin3NF: Hey ACME developer...you have a 2 day old transaction taking up all your T-log space...
Acme: ok...let me truncate the log
Kevin3NF: WAIT A SECOND!
Acme: Did that help?
Kevin3NF: No. You just invalidated the T-log backup stream and started causing the backup to fail
Acme: Why?
Kevin3NF: Cuz that big open transaction is still there, and SQL Server thinks there is no full backup now.
Kevin3NF: Hello?
Kevin3NF: (Sees pictures of crickets in his Inbox)
Acme: (hours later): go ahead and run a full backup tomorrow afternoon
Kevin3NF: You know you don't have a valid backup to recover to, right?
Acme: Yes, but we can't backup now...
(tomorrow afternoon):
Acme: Hey...who told you to run a full backup?!?!?
Kevin3NF: You did...I have the email.
Acme: (complaint to Kevin3NF's bosses)
Time passes...repeat scenario.
Big transaction, full log file, fill drive, lather, rinse, repeat.
Customer: FAIL. >:(
Acme me owes ME some fries...but I get paid to deal with stuff like this every day :)
Kevin3NF
