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
5/03/2013
6/07/2011
4/15/2009
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
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
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
11/25/2008
SQL PASS Community Summit 2008
Wow. What a load of information! Almost an overload, but managed to keep my head above the water in almost every session.
The breakdown:
Day 1:
SQLCAT - Overall Lessons Learned from SQL 2008 Experiences
Quite a good bit of variety here, touching on:
Data Compression
Backup Compression
Performance Tuning (Extended Events)
SQL Server Reporting Services
Database Mirroring (compressed LogStream)
EncryptionCapitalizing on the SQL Server 2005 System Information
Way more info here than I was able to process...took a few notes to look up after Thanksgiving
Understanding and Troubleshooting Transactional Replication Performance
Lots of discussion on subscription streams/mutli-threading and read/write activity of the Log Reader and Distribution Agents. Got a few things to play with.
SQL Server 2008 Policy-Based Management - Sharon Dooley
Not a whole lot here I didn't pick up at the SQL 2008 launch in LA...still a very cool feature I won't get to use much in our environment.
Day 2:
Guiding your Query Plans (by Kalen Delaney)
Guiding query plans didn't actually enter the picture until late in the presentation, but it was fantastic nonetheless. Most of this session was about Hints...Table, Index, Option, etc. A BUNCH of stuff that never crossed my monitor before. 3 pages of notes worth. Being able to force a recompile of a portion of the overall query is really slick. And the very simple new feature of assigning a value in the declare:
DECLARE @MyID INT = 123
Smart Database Design - MVPs DrSQL and Paul Nielson
Well outside of what I do from day to day, but pretty cool anyway, since I was a developer many moons ago. Worth the lack of elbow room just to hear from DrSQL and Paul live...too bad my on call phone went a little nuts and I had to leave early
Advanced Troubleshooting with SQL Server Extended Events
So far over my head I'm still not sure what I learned...good thing I have notes
Business Continuity with Backup and Restore - Peter Ward
I could probably have taught this session. Should have been labeled 200 level, but still good solid information on backup/restore and some of the new (05/08) options (Online restore, Partial, COPY_ONLY, etc.). Thought about arguing a point with Peter, but decided the way he presented his wasn't likely to cause harm.
Day 3:
Data and Backup Compression Lessons Learned
Some fairly impressive numbers here...300GB DB compressed to 45GB, 50% time savings, etc.
Money-maker: use sp_estimate_data_compression to do custom analysis for customers considering whether to move to SQL compression. Assuming you have the install to do it on.
Collecting and Analyzing Performance Metrics in SS2005/8
Got here late, stuck in the back, couldn't see or hear very well. Saw a little perfmon on the screen I think...
Writing Technical Articles (Kathi Kellenberger)
The only Personal Development session I attended, since I was on the company nickel. Interesting stuff. I've thought about teaching and writing a SQL Basics series for new or accidental DBAs that really will never do more than backup/restore or set up Dev systems. Kathi Kellenberger did a fine presentation, including various places to publish to, and what they pay (if anything). I'm completely convinced to NEVER get in on a book project :)
End-to-end troubleshooting for SQL Server 2005
Kevin Kline rocks. Many others have blogged this presentation, so I won't repeat here.
11/17/2008
11/11/2008
I hate it when that happens...
A good friend of mine has a fairly simple community site, with 30K members, about 7K active.
SQL Server 2000, ASP Classic. DB and site on separate servers.
KerBam! SQL Injected last Monday. Major trashing of data.
Problem 2: No backup since October 2, as the SQL Agent password had changed so the Agent wasn't started.
Problem 3: Started the agent and it deleted the last full backup because it was older than 4 weeks.
SO: I get the call for help.
Time passes.
More time passes.
After a dozen uploads and downloads of .mdf/.ldf and backup files (from August), I am able to recover much of the data using the fantastic tools from Red-Gate software:
Log Rescue: Identified what got injected, into where and when
SQL Compare: enabled me to create a schema script to replace the relationships I had to remove to fix the data
SQL Data Compare: Helped me replace the trash data with what it looked like in August.
Also, a shout-out to Narayana Vyas Kondreddi for his Search and Replace code that at least got the bad URL out of the data we couldn't fix.
The site is back up in read-only, and my buddy is reviewing all the code one page at a time.
Lessons learned:
Validate your inputs!
Back up your data, and verify it!
Not only does this one get fries, he gets 10+ hours of recovery effort at no charge, just for having a really cool site I want to see come back up :)
Kevin3NF
A good friend of mine has a fairly simple community site, with 30K members, about 7K active.
SQL Server 2000, ASP Classic. DB and site on separate servers.
KerBam! SQL Injected last Monday. Major trashing of data.
Problem 2: No backup since October 2, as the SQL Agent password had changed so the Agent wasn't started.
Problem 3: Started the agent and it deleted the last full backup because it was older than 4 weeks.
SO: I get the call for help.
Time passes.
More time passes.
After a dozen uploads and downloads of .mdf/.ldf and backup files (from August), I am able to recover much of the data using the fantastic tools from Red-Gate software:
Log Rescue: Identified what got injected, into where and when
SQL Compare: enabled me to create a schema script to replace the relationships I had to remove to fix the data
SQL Data Compare: Helped me replace the trash data with what it looked like in August.
Also, a shout-out to Narayana Vyas Kondreddi for his Search and Replace code that at least got the bad URL out of the data we couldn't fix.
The site is back up in read-only, and my buddy is reviewing all the code one page at a time.
Lessons learned:
Validate your inputs!
Back up your data, and verify it!
Not only does this one get fries, he gets 10+ hours of recovery effort at no charge, just for having a really cool site I want to see come back up :)
Kevin3NF
9/17/2008
Do what?
Too good to be true, but it is...
From: My Customer
Sent: Tuesday, September 16, 2008 9:37 AM
To: Kevin3NF
Cc: a bunch of people
Subject: Re: SQL Backup
Hi,
As per latest discussion with {Customer DBA} only one database will be backed up - "MyDatabase". Please exclude other three databases from backup process.
Differential backup should be from Monday [after taking of full backup] - Sunday.
-Customer
----- Original Message -----
From: Kevin3NF
To: My Customer
Sent: Tuesday, September 16, 2008 9:41 AM
Subject: RE: SQL Backup
Full backup at 12:15am and differential 15 minutes later at 12:30? We can do that…
----- Original Message -----
From: MyCustomer
Sent: Tuesday, September 16, 2008 9:43 AM
To: Kevin3NF
Subject: Re: SQL Backup
yes that's correct.
Apparently they anticipate a lot of traffic the first 15 minutes of Monday morning each week :)
Sigh.
Kevin3NF
Too good to be true, but it is...
From: My Customer
Sent: Tuesday, September 16, 2008 9:37 AM
To: Kevin3NF
Cc: a bunch of people
Subject: Re: SQL Backup
Hi,
As per latest discussion with {Customer DBA} only one database will be backed up - "MyDatabase". Please exclude other three databases from backup process.
Differential backup should be from Monday [after taking of full backup] - Sunday.
-Customer
----- Original Message -----
From: Kevin3NF
To: My Customer
Sent: Tuesday, September 16, 2008 9:41 AM
Subject: RE: SQL Backup
Full backup at 12:15am and differential 15 minutes later at 12:30? We can do that…
----- Original Message -----
From: MyCustomer
Sent: Tuesday, September 16, 2008 9:43 AM
To: Kevin3NF
Subject: Re: SQL Backup
yes that's correct.
Apparently they anticipate a lot of traffic the first 15 minutes of Monday morning each week :)
Sigh.
Kevin3NF
8/07/2008
So SQL 2008 went RTM yesterday...cool.
Now, to dig in and see what (if any) of the really cool new features moved to the standard version instead of Enterprise. Or even stuff from 2005 moving into standard...
Post a comment if you already have the list :)
OK...here we go:
Features Supported by the Editions of SQL Server 2008
http://msdn.microsoft.com/en-us/library/cc645993(SQL.100).aspx
Backup compression: Enterprise only. No thanks, I'd rather buy Litespeed or Red Gaet SQL Backup than pay this premium :(
Encryption: Enterprise only (TDE and Data Compression): Great feature, easier to use, worth the expense for some companies/industries
Resource Governor: EE only...cool feature, but I wonder how often it will get used in practice
Database Mirroring: Yes (safety full only) in Standard edition
Auditing: EE only. Someone is going to blow performance out the door by auditing everything...be judicious here folks!
Capacity Specifications for SQL 2008 objects:
http://msdn.microsoft.com/en-us/library/ms143432(SQL.100).aspx
Maximum Number of Processors Supported by the Editions of SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms143760(SQL.100).aspx
A Processor is still defined as a socket here, so 4 quad cores gives you a SE SQL Server with 16 CPUs.
Memory Supported by the Editions of SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms143685(SQL.100).aspx
Workgroup edition got a 1gb bump here
And my favorite feature thus far is still the very configurable installer. I install at least 1 SQL Server per week and despise having to physically move the system databases and set the default locations after he install for the user dbs. There are (too?) many options in this installer that were simply not available pre-2008. Rockin'
So, there's some links and my take on a few pieces.
Fries and a shake to MS for not slipping the date to Q4!
Kevin3NF
Now, to dig in and see what (if any) of the really cool new features moved to the standard version instead of Enterprise. Or even stuff from 2005 moving into standard...
Post a comment if you already have the list :)
OK...here we go:
Features Supported by the Editions of SQL Server 2008
http://msdn.microsoft.com/en-us/library/cc645993(SQL.100).aspx
Backup compression: Enterprise only. No thanks, I'd rather buy Litespeed or Red Gaet SQL Backup than pay this premium :(
Encryption: Enterprise only (TDE and Data Compression): Great feature, easier to use, worth the expense for some companies/industries
Resource Governor: EE only...cool feature, but I wonder how often it will get used in practice
Database Mirroring: Yes (safety full only) in Standard edition
Auditing: EE only. Someone is going to blow performance out the door by auditing everything...be judicious here folks!
Capacity Specifications for SQL 2008 objects:
http://msdn.microsoft.com/en-us/library/ms143432(SQL.100).aspx
Maximum Number of Processors Supported by the Editions of SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms143760(SQL.100).aspx
A Processor is still defined as a socket here, so 4 quad cores gives you a SE SQL Server with 16 CPUs.
Memory Supported by the Editions of SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms143685(SQL.100).aspx
Workgroup edition got a 1gb bump here
And my favorite feature thus far is still the very configurable installer. I install at least 1 SQL Server per week and despise having to physically move the system databases and set the default locations after he install for the user dbs. There are (too?) many options in this installer that were simply not available pre-2008. Rockin'
So, there's some links and my take on a few pieces.
Fries and a shake to MS for not slipping the date to Q4!
Kevin3NF
6/26/2008
I can't make stuff up this good...
Scenario:
Major website in the IT industry, very well known. Perf issue, most likely related to inefficient queries and/or indexes and stats. Site timeouts all over the place.
Sent customer a list of long running queries and got this:
{Customer} says they are in the process of getting rid of the site. He said use gum and bailing wire for the time being. Thanks for you hard work.
Sadly, I am out of gum and bailing wire. Will spit and duct tape do?
Simply amazing.
Kevin3NF
Scenario:
Major website in the IT industry, very well known. Perf issue, most likely related to inefficient queries and/or indexes and stats. Site timeouts all over the place.
Sent customer a list of long running queries and got this:
{Customer} says they are in the process of getting rid of the site. He said use gum and bailing wire for the time being. Thanks for you hard work.
Sadly, I am out of gum and bailing wire. Will spit and duct tape do?
Simply amazing.
Kevin3NF
5/22/2008
SQL Injection...restore, plug, repeat
Customer: Please restore my database
Kevin3NF: Sure thing...what happened?
Customer: SQL Injection...spam in my data
Kevin3NF: OK...have you plugged the holes in the application?
Customer: Not yet...but our site is down
Kevin3NF: Talk to you tomorrow.
Repeat ad nauseum...
You get no fries for bad coding practices. Matter of fact, you get drive-through service only. And your DB is now read-only!
:)
Kevin3NF
Customer: Please restore my database
Kevin3NF: Sure thing...what happened?
Customer: SQL Injection...spam in my data
Kevin3NF: OK...have you plugged the holes in the application?
Customer: Not yet...but our site is down
Kevin3NF: Talk to you tomorrow.
Repeat ad nauseum...
You get no fries for bad coding practices. Matter of fact, you get drive-through service only. And your DB is now read-only!
:)
Kevin3NF
5/16/2008
Newest SQL Injection attack
I just watched part of the SSWUG show 106, where SQL Server MVP Stephen Wynkoop dissected the current SQL Injection attack that is propogating itself around the net. The 'cool' thing with this one is that instead of passing in SELECT, UPDATE, etc statements to your SQL Server, its doing a CAST of a binary string into an NVARCHAR 4000 data type. That binary string translates to an UPDATE statement that craps up all of your tables, as long as drive space is available.
So...if you are filtering on keywords, your filters will not work.
Move to stored procs...now.
I saw the tail end of this yesterday. The only reason my customer didn't suffer worse is that they had a database size cap of 150mb (shared SQL Server), and we started looking into the unexpected growth.
Take care out there!
Kevin3NF
I just watched part of the SSWUG show 106, where SQL Server MVP Stephen Wynkoop dissected the current SQL Injection attack that is propogating itself around the net. The 'cool' thing with this one is that instead of passing in SELECT, UPDATE, etc statements to your SQL Server, its doing a CAST of a binary string into an NVARCHAR 4000 data type. That binary string translates to an UPDATE statement that craps up all of your tables, as long as drive space is available.
So...if you are filtering on keywords, your filters will not work.
Move to stored procs...now.
I saw the tail end of this yesterday. The only reason my customer didn't suffer worse is that they had a database size cap of 150mb (shared SQL Server), and we started looking into the unexpected growth.
Take care out there!
Kevin3NF
3/03/2008
Thud.
By comparison to the SQL 2005 launch, Los Angeles was a dud.
Too many people seemed to overwhelm the facilities. many of the sessions were packed to the gills, long lines for everything.
The SQL Server "Ask the experts" section in the Microsoft Pavillion was unstaffed, even after I found the guys that were supposed to be in it and showed them where it was.
LA Convention center stopped letting folks into the Partner pavillion after about 4, so I missed the other half of the vendors I had intended to visit.
Bah, humbug.
What's cool? (I can spin anything...). I did learn about a number of new features in SQL 2008 that I had previously not paid any attention to and the hands-on lab for Change Data Capture was a quick way to get up to speed on the idea/concepts of this so I can share with my customers.
Did you go? What was your experience?
Kevin3NF
By comparison to the SQL 2005 launch, Los Angeles was a dud.
Too many people seemed to overwhelm the facilities. many of the sessions were packed to the gills, long lines for everything.
The SQL Server "Ask the experts" section in the Microsoft Pavillion was unstaffed, even after I found the guys that were supposed to be in it and showed them where it was.
LA Convention center stopped letting folks into the Partner pavillion after about 4, so I missed the other half of the vendors I had intended to visit.
Bah, humbug.
What's cool? (I can spin anything...). I did learn about a number of new features in SQL 2008 that I had previously not paid any attention to and the hands-on lab for Change Data Capture was a quick way to get up to speed on the idea/concepts of this so I can share with my customers.
Did you go? What was your experience?
Kevin3NF
2/26/2008
Heros Happen Here? SQL 2008 launch...
I'm headed out to LA today for the Windows/SQL/VS 2008 launch event, and have lots of tech stuff in my head to wonder about, but I keep amusing myself with the theme of this event:
Heros Happen Here. "Celebrating and Inspiring Customer Heroes"
I really don't know what to expect. Are we going to get to meet the guy that saved the company from impending doom at 3AM (again)? How about the SQL developer from Redmond that found a last minute bug in some cool new feature?
Or will there be speeches from real heroes, such as people who have saved lives, or invented new nedical technologies?
Worst thought: At the SQL 2005 launch ("Rock the Launch"), there were celebrity impersonators all over the place...Cher, Tina Turner, Britnney "Pre-crack-up" Spears...
Please don't tell me we are going to have hired actors walking around dressed like Police, soldiers, firemen and EMTs...
I'll report back what Microsoft calls a hero when/if I figure it out :)
If you're there, look for me....I'll be the middle-aged, balding guy with a gut, a goatee, a laptop and two phones. That oughta narrow it down for you!
Kevin3NF
I'm headed out to LA today for the Windows/SQL/VS 2008 launch event, and have lots of tech stuff in my head to wonder about, but I keep amusing myself with the theme of this event:
Heros Happen Here. "Celebrating and Inspiring Customer Heroes"
I really don't know what to expect. Are we going to get to meet the guy that saved the company from impending doom at 3AM (again)? How about the SQL developer from Redmond that found a last minute bug in some cool new feature?
Or will there be speeches from real heroes, such as people who have saved lives, or invented new nedical technologies?
Worst thought: At the SQL 2005 launch ("Rock the Launch"), there were celebrity impersonators all over the place...Cher, Tina Turner, Britnney "Pre-crack-up" Spears...
Please don't tell me we are going to have hired actors walking around dressed like Police, soldiers, firemen and EMTs...
I'll report back what Microsoft calls a hero when/if I figure it out :)
If you're there, look for me....I'll be the middle-aged, balding guy with a gut, a goatee, a laptop and two phones. That oughta narrow it down for you!
Kevin3NF
1/31/2008
3NF Consulting is dead...
After 6 good years and 1 not so good, 3NF Consulting is shutting down. I want to thank all of my former clients, vendors and most of all the outstanding crew of Access, SQL Server and Windows guys I have farmed work out to over the years. We did some good work, saved a few necks and put out more than few fires along the way.
Despite the demise of the company, I'll still be doing some side work as Kevin3NF, the 1099 guy, on a 1-2 hour basis. No long-term stuff as I am quite content at my full-time gig.
Thanks for reading...
Kevin3NF
After 6 good years and 1 not so good, 3NF Consulting is shutting down. I want to thank all of my former clients, vendors and most of all the outstanding crew of Access, SQL Server and Windows guys I have farmed work out to over the years. We did some good work, saved a few necks and put out more than few fires along the way.
Despite the demise of the company, I'll still be doing some side work as Kevin3NF, the 1099 guy, on a 1-2 hour basis. No long-term stuff as I am quite content at my full-time gig.
Thanks for reading...
Kevin3NF
1/25/2008
Count your zeros....Or, "I want that system"
I was asked to give a once over to a system not built by my team. SQL 2000 32-bit on Windows 2003 64 bit. 40GB RAM.
Min and Max set to 32gb, yet Perfmon is showing 40gb used by SQL Server. Hmm.
Freakshow noticed that the Min and Max Server memory settings seemed a little high at 33000000. 33000000/1024 = 31.4 Terabytes of RAM. Sweet.
Linchi Shea from the .server newsgroup noticed it as well.
We set it to a more conservative 36gb.
You want room for the O/S with that?
Kevin3NF
I was asked to give a once over to a system not built by my team. SQL 2000 32-bit on Windows 2003 64 bit. 40GB RAM.
Min and Max set to 32gb, yet Perfmon is showing 40gb used by SQL Server. Hmm.
Freakshow noticed that the Min and Max Server memory settings seemed a little high at 33000000. 33000000/1024 = 31.4 Terabytes of RAM. Sweet.
Linchi Shea from the .server newsgroup noticed it as well.
We set it to a more conservative 36gb.
You want room for the O/S with that?
Kevin3NF
1/24/2008
Your master db is how big?
Caller: My master database is 500mb, and I'm running low on drive space
Kevin3NF: 500mb is small...you're that low on space? What did you create in the master db?
Caller: Nothing
Kevin3NF: What about these three user tables named "Trace1, trace2 and trace3?"
Caller: Oh yeah...forgot about those. I'll delete them.
Kevin3NF: You want fries or a salad with that?
:)
If you are going to save your Profiler trace data to a table, please create a database named "Traces" and save it there...
Master database doesn't accrue much information day to day, so should almost never grow to more than 100mb or so. It is more metadata than anything else.
Kevin3NF
Caller: My master database is 500mb, and I'm running low on drive space
Kevin3NF: 500mb is small...you're that low on space? What did you create in the master db?
Caller: Nothing
Kevin3NF: What about these three user tables named "Trace1, trace2 and trace3?"
Caller: Oh yeah...forgot about those. I'll delete them.
Kevin3NF: You want fries or a salad with that?
:)
If you are going to save your Profiler trace data to a table, please create a database named "Traces" and save it there...
Master database doesn't accrue much information day to day, so should almost never grow to more than 100mb or so. It is more metadata than anything else.
Kevin3NF
Subscribe to:
Posts (Atom)