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 |
|
mr_luckly
Starting Member
1 Post |
 Posted - 2005-01-31 : 08:15:10
|
| Hello, We have a microsoft cluster set up with several different databases, we have 5 different webservers that connect to the databases nad a very frequently visited site. a couple of days back we starrted experiencing a problem when posting data into one of the databases, the specific database is the biggest one we have, just below 8 gb of data ( all of the data is basically in 2 different tables).we run w2k advanced serve service pack 4 , ms clustering , sqlserver sp3.we started getting messages of timeouts from the webservers, so the timeout was because data couldnt be posted in the database.after trying to figure out what the problem was , running dbcc checkdb etc i found no errors, but decided to restore a backup. , i did so and things worked perfect again. but only for a days time.. this of course made me consider database /table size being a problem, i now deleted the tables that contained the data and scripted new ones, that "solved" the problem of being able to post data , BUT, we need to have the other data in there as well. i am a bit at a loss now , aný clues out there? Friendly RegardsDavid |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-01-31 : 10:16:16
|
| You don't give us enough info to help you. What are the queries that are failing? Post the DDL of your tables and indexes and views.Are you using any stored procedures or functions? Post them as well.-ec |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-31 : 13:05:50
|
just below 8 gb of data ( all of the data is basically in 2 different tables).Well, you could start there.  Did you try to UPDATE STATISTICS or rebuild indexes on the tables before you blew them away? Have you used Performance Monitor or Profiler to see what's causing the issue? Did you plan how you were going to get the data back before you did this? Do what ec said, and we'll see if we can help. You might want to consider investing some time and money into a DBA though.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-01-31 : 18:15:06
|
| yeah a little normalization and some indexes will go along way. I still want to see the DDL though.-ec |
|
|
|
|
|
|
|
|
8gb clustered database getting timeout errors?