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 |
|
deepak.sakpal
Starting Member
1 Post |
 Posted - 2010-08-19 : 03:15:12
|
| We are simple vb.net program and SQL 2000 is Database server for this fronted.My back office team just copy pest the news article in respective program and attached scan copy of artical also attached with is program. my senior back office people are check and send it to respective client. All these test are stored in SQL and scan copy pointer in SQL. Also web application running on the same server. When the client is received the mail from our side. They received the link of articals and when click on link it is open from our web server. My queries are :-When senior back office people are attached and view the image, it give the time out error every time. also accessing the data from the front end software it takes time to came out to display.My data base size is - 18 GB and index is 80 GB Database record are 10,00,000 Hardware configXenon Processor 3.0 Ghz Single processor10 GB RAMRAID 5 for dataplease let me know, how to resolved this issue.ThanksDeepak SakpalReply on my email - deepak.sakpal@gmail.com |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-19 : 13:30:38
|
| Are you storing image in SQL DB or in file system?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2010-08-19 : 14:20:59
|
| Am I reading this right?You have 18 GB of data and index size is 80 GB? Can you explain that.Mike"oh, that monkey is going to pay" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-20 : 01:58:39
|
| LDF/LOG is 80 GB perhaps? I seem to remember a client back in the days of SQL 2000 having a huge Log which adversely effected performance on the DB. |
|
|
|
|
|
|
SQL Performance Issue