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 |
|
mscic
Starting Member
2 Posts |
 Posted - 2007-10-04 : 11:16:10
|
| Running SQL 2005 on a dedicated Dual Xeon 8MB RAM AND 6x 160GB HDDS RAID-5. Front end App Access 2002. I have to main concerns. 1. When users are enter data and saving all of a sudden all users get stuck upon saving and requires to reboot the server to operate again. Th eproblem is that this happens 3 to 5 times a day. Also searching records with one word takes very long time sometimes even minutes, but queries having two or more words come up fast. Also single word queries come up with erratic results, sometimes 200 titles and than a second search comes up with 31,000. *** Can anyone come up with any ideas "off the cuff" on how I canstart to resolve these issues. Can these issues be related? |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-10-04 : 11:33:26
|
| Dual Xeon 8MB RAM AND 6x 160GB HDDS RAID-5.1). Are you sure? 8Gig RAM maybe. Is 800GB for storage space enough? If you have to keep rebooting your server, there is most likely some hardware failure going on somewhere.There is no way to tell how to speed up your queries unless we saw them, the underlying tables, and the indexes and keys.[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
mscic
Starting Member
2 Posts |
Posted - 2007-10-05 : 02:14:44
|
| Thanks for your interest DON. Sorry, typing error for RAM it is 8GB! AWE Activated min serv memory set at 1Gb and MAx set at 7Gb. The PAE in bootini is also set and Memory page Lock set too. As for HHD Space the DAta is only using 173Gb and the system is Partitioned at 40gb using only 12.7Gb.Let me explain myself better. When I said system halts, is that all users when they go to save a record all get stuck with the hour glass, some get an OBDC error 3156 but the server actually is free and running. If users wait for a couple of mins (and not secs), than closing the access app works again but than everything is slow. The way I see it, I thibk that SQL goes in some error state which I cannot see from event logs etc. I hope the above gives more insight to my difficulty.As for query speed, Do you attribute it entirely to the code? Did I understand right? Just for the info I did not write the software front end, I am no programmer. I will follow the links you suggested.Thanks MAte |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-10-05 : 07:05:26
|
| Query speed is entirely dependent on the code, the indexes on the tables inside the database, and the hardware it is running on.Try googling ODBC error 3156.(ODBC - delete on a linked table <name> failed) [Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-05 : 22:56:12
|
| Did you see blocking on the server? How often do you rebuild index or update statistics? |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
|
|
Access halta on saving records, restart server req