| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2004-08-23 : 15:59:32
|
| Anyone got a good URL on how to instruct SQL 2000 to share memory with IIS without fighting over it? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-23 : 16:23:45
|
| Ugh. Why would you want to do this? I don't think that you can tell IIS to use a fixed size, but you can with SQL Server, although I don't ever set this as ours are always dedicated boxes.Tara |
 |
|
|
MuadDBA
628 Posts |
Posted - 2004-08-23 : 16:25:03
|
| I've got a good URL that will tell you never to share your IIS Server with your SQL Server....www.sqlteam.com |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-08-23 : 16:40:06
|
Thanks  |
|
|
|
Martin Babb
Starting Member
11 Posts |
Posted - 2004-08-24 : 02:32:17
|
| Sql Server and IIs are both self tuning and will spend some of their resources fighting for resources.No point really |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-08-24 : 08:44:32
|
| Let me phrase the question differently then.What tools / what measurements would indicate that more memory would improve the performance of a combined IIS / SQL server? |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-08-24 : 09:53:58
|
| You could look at page faults/second, and watch it over time. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-24 : 12:00:03
|
| If I combined them, which I never would as that would make me a sucky DBA, then I would more than double the RAM if they were on separate machines. So if my web server normally would have 2GB and my db server normally would have 2GB, then I would probably have 5GB+ on the combined machine.Tara |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-08-24 : 13:03:19
|
I think Tara just called me a suckey DBA ! Maybe Graz should implement a counter on our profiles. If we get too many negative votes from other members, "You're Fired!"  Anyway, it's a question of economics. I'd love dual servers. I really want a separate spindle for the database. It's a question of balancing budgets and by the way, there don't seem to be any performance issues at all anywhere (yet). Knock on wood.But we're growing, and I expect one day we'll either add a second server because it's easily affordable, or because the server is taken to it's knees. I'd like to get some first-hand experience viewing metrics to raise a red flag before that happens.Sam |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-24 : 13:09:15
|
quote:
Originally posted by SamC
I think Tara just called me a suckey DBA !
Nah...aren't you filling the role of a DBA but you're mostly a developer? Developers filling the role get more leniency than a full-time DBA that should know better.Tara |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-08-24 : 13:15:48
|
| Thanks! No bad mark on my record then?It's true. I read a post somewhere from a guy who claimed to have a lot of watered-down expertise in many subjects. I know his pain.I spend a disproportionate amount of time in SQL because the return on investment is higher than writing comparable code in ASP or .NET. Not to mention SQL kicks ass whenever performance is an issue.Sam |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-08-24 : 13:36:15
|
| i know what you mean with that.... i just loved the looks on my previous coworkers faces, when i wrote an sql statement that did the same thing as very much lines of code in c#.it also shortened the time from 3 minutes to 5 seconds...it's times like that when time spent learning it and hanging here is well spent.Go with the flow & have fun! Else fight the flow :) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-08-24 : 13:48:06
|
quote:
Originally posted by tdugganNah...aren't you filling the role of a DBA but you're mostly a developer? Developers filling the role get more leniency than a full-time DBA that should know better.
Hey there's always a cut over at some point....Damn the .net torpeadoes....full dba skills ahead.....But I wouldn't suggest just being a pure production dba.....How about system architect....it all starts with the db anyway....Or...window washer.....Oh, and tell the cheap son of a beaches to lay out some cash....Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-24 : 13:54:06
|
| Yeah definitely not a pure production DBA. That's pretty much what I was at my last job. Mostly fighting fires. Glad those days are over.Tara |
|
|
|
Martin Babb
Starting Member
11 Posts |
|
|
|
SQL Memory Allocation