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 |
|
sandhyakalsotra
Starting Member
22 Posts |
 Posted - 2010-09-05 : 11:01:56
|
| Hi,We have servers in our office branches holding data regarding electricity bills for 25000 consumers in 30 different tables of billprocessing,revenue,meterread & so on. Lately,we required to generate some information based on these tables and to make the process easier, our vendor provided us with a modified version wherein a new table has been added and after running the query,this table gets populated and result is reflected at the client end. So far so good, but the problem started with a couple of servers,when we updated the version, every other report is getting generated but when trying to generate this new report, after a while a message of time out flashes. It's only with 2 servers and when we restore a copy of this data on some dummy, it gets executed. we formatted the server and relaoded the SQL but the problem persists. Please help me out.sandhya |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-09-05 : 11:24:05
|
| what do you mean when you say servers? one server should be enough to hold 30 tables and 25.000 customer information.What do you mean with "updated the verion"?What kind of message do you receive when running report (in SSRS?)there are several issues here, and it's hard to pinpoint what might be the reason behind your problem. you should tell more and systematically eliminate problems. |
 |
|
|
sandhyakalsotra
Starting Member
22 Posts |
Posted - 2010-09-05 : 12:17:20
|
| see, we have different servers at district level for their specific data and its processing and billing. Each one caters to 25000 consumers at an average.updated means...added one more table the message received is "time out"sandhya |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sandhyakalsotra
Starting Member
22 Posts |
Posted - 2010-09-05 : 15:20:57
|
| hi tkizer,run update say once in an year. no, I haven't run the missing indexes report.sandhya |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
I am lost