Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2004-10-25 : 02:08:45
|
| Hi,My SQL server has started getting really slow. I've optimized my web tier with caching as much as I can, I see room for some improvement which I will work on however I don't think it changes the fact I am outgrowing my box any day.My WebServer is under almost no stress compared to my SqlServer. I was thinking about putting MSDE on it to store parts of the database that could be separated. One part I was thinking of separating is the internal mail system. I could change the design slightly so it does not need to join onto other tables and I could just store this one table on MSDE.What do you guys think of a solution like this? Any drawbacks on MSDE ? I am currently paying for a 2 processor license for my reg server but can't even come close to affording the move to enterprise. Could I create this table / DB and in MSDE on my webserver and have my ASPX pages execute the pages while grabbing from two different datasources? Is this a bad solution? Any speed drawbacks on MSDE? I think I can live without the tools I need for my main server as there will not really be any maintenance for this table. I assume its easy to recreate in MSDE what I've already done in SQLSERVER?Any suggestions greatly appreciated.Thanks again guysmike123 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-10-25 : 08:50:47
|
| I would look at what you are doing on the sql server and look to optimising the queries / database structure.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2004-10-26 : 22:08:42
|
| Hi NR,I am looking at the database and I believe there is definately room for optimizing that should make the database run alot faster. I am in the process of doing this right now.The thing is its just going to buy me time as I need to handle double the load in the near future. What other alternatives do I have?Thanks againmike123 |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-10-27 : 00:49:13
|
| I've actually done exactly what you're talking about before. We seperated some of our static reference tables we used into a seperate MSDE installation on the app servers. It worked. I wouldn't recommend doing it if you don't have to. I also wouldn't recommend putting any sensitive data (like email addresses) in a SQL Server installation on the web server. That's just asking for it. Just a thought.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2004-10-27 : 02:05:30
|
| Hi Derrick,I really don't want to either. I will run some profiling and see how much resources the mailbox system is really taking and see if its worth it. I would have to do a little denormalizing of the database, which again I do not want to do.Why wouldn't you store email addresses on the webserver? I don't plan on it, but interested to know why. Did you have any downfalls in running MSDE? Could a dual processor box run it efficiently?Any other ways you can suggest to maybe approach this?Thanks alot for your help!mike123 |
|
|
|
|
|
|
Using 2 SQL Servers for one application ?