| Author |
Topic |
|
mmantha
Starting Member
2 Posts |
 Posted - 2004-07-14 : 19:59:56
|
| We need someone with top credentials and experience to resolve SQL timeouts for an ecommerce web site.The server requiring solution is located at: Access Northeast, 321 Central Street, Hudson, MA 01749The ecommerce web site was created in ASP and resides on an SQL server. You may require a good knowledge base in ASP programming. When the server reaches 300 to 400 users, the server will timeout. NOTE: Other companies have been unable to resolve the problem.The interim fix has been to implement a script to reboot at regular intervals. The problem needs to be identified and fixed.If you are in this area (Hudson, MA) and have the experience and expertise, email me at admin@therealdotin.com and include your phone number in the email.If you can solve the problem, we will award you $500, plus a potential server maintenance contract.THIS IS NOT AN AMATEUR CHALLENGE. You will have credentials and references, and min. of 5 years experience with SQL up to current SQL. Only qualified persons please.We will only respond to selected candidates.Email me at admin@therealdotin.com and include your phone number in the email.Good luck!Best regards,Marc Mantha |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-07-14 : 20:37:50
|
| Call microsoft, get PSS involved. It will cost you $234.-ec |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-14 : 23:06:36
|
| I wish we only had 300-400 users. :) We have more transactions a second then that a log of times.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-15 : 08:57:23
|
| I was curious about this. Whilst I can see the potential for a solution I can't see that someone who could REALLY solve the problem would do so for $500. Sure if they can put their finger on it straight away that would be an easy earner but: "NOTE: Other companies have been unable to resolve the problem". And eyechart is quite right that PSS would be the best value.But other than that I reckon there might easily be a couple of days involved in understanding the system, profiling it, making changes in a "safe environment" - which may easily mean create a database on some DEV kit and getting a, possibly, massive database across.So for someone good I would reckon we are up to $2,000 at least.However, I would also expect "someone good" to be up for a no-fix-no-fee type deal.Just my $0.02, and I'm way out of range of Hudson, MA.Kristen |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-07-15 : 08:59:01
|
quote:
Originally posted by derrickleggett
We have more transactions a second then that a log of times.
Was that intentional?In any case I thought that was funny...I had a benefits registration system...40,000 users...had a window of a couple of months....they all went on at the last couple of days...$500? Hell that's not a lot a tequila. And besides, it's not the database!Why do they always blame the database?You Dr., Mister MD! How far is Hudson, that's what's ailing me....(Hint: Ain't even worth his gas)Brett8-) |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-07-15 : 10:41:31
|
| hard to get excited for $500. Make it $5000 w/ expenses paid and you might have some takers.-ec |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-07-15 : 11:13:34
|
| is the server using lots of session variables? sounds like an ASP issue ....how far is hudson from boston?make it $1,000 and I might take a look ....- Jeff |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-07-15 : 11:57:49
|
quote:
Originally posted by mmantha
THIS IS NOT AN AMATEUR CHALLENGE.
But it is an AMATEUR request....I wonder if they've isolated sql server and the application to their own boxes....And dude....16 meg just don't cut it anymore......Brett8-) |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-07-20 : 18:05:25
|
| I'd have to agree that this is more likely and ASP issue than a SQL Server issue. I did quite a bit of web app (ASP) load testing for a client a couple of years ago, and while we stressed IIS/ASP to it's death (had to reboot the server a number of times) SQL Server didn't break a sweat. I'm sure any previous professional consultants already went in and looked at the Requests Queued and found them way out of line but didn't figure out a solution in time, or at least not one that the client would accept.And let's say you're really cheap, and only charge $30/hour. That only gives you two days (16 hours) to figure out the problem AND implement a solution before you start losing money on the proposition. And anyone with 5 years of SQL Server experience is charging more than $30/hour. Not to mention the rates that someone who understands all the tweaking options inside IIS would charge. That maintenance contract that the MIGHT offer you better be significant. Or I hope someone decides to take this on as a school project or charity case. Maybe someone who needs a good reference more than they want the money will go for it.-----------------------------------------------------Words of Wisdom from AjarnMark, owner of Infoneering |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-20 : 19:35:11
|
| For $500, it better be be for an amateur. :) I charge $85/hr if you loose enough business and get desperate by the way. You can hire me for a minimum 20 hour engagement. I have a high opinion of myself, and consider myself worth a log.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-07-20 : 20:04:49
|
quote:
Originally posted by derrickleggett
I have a high opinion of myself, and consider myself worth a log.
There he goes mixing his g's and t's again... Have a martarigga on me! -----------------------------------------------------Words of Wisdom from AjarnMark, owner of Infoneering |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-07-20 : 20:11:35
|
| Derrick likes to get paid in logs??Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-20 : 20:12:52
|
| Yes, bit logs full of imporgang informagion and breggarigas.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-07-21 : 15:31:26
|
| Have ghey've tone oug of business yeg?I wonder what the service maint contract is...$250/unlimited a year?Brett8-) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-21 : 15:37:48
|
| Well, let's hope they went the Microsoft $250 single incident route, and saved themselves $250.Otherwise they are in for a $5,000 bill to get "someone with top credentials and experience" to sort it out. By which time I presume the Business Opportunity Cost cost centre will have LOST several orders-of-magnitude of that.As my Father used to say: "The first loss is the best loss"Kristen |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-07-22 : 09:10:15
|
quote:
Originally posted by Kristen
As my Father used to say: "The first loss is the best loss"
Defenitley a guy....Brett8-) |
|
|
|
|
Solve timeouts - earn $500