Database is too slow

[desireemm]

Hi guys I got a database with SQL server 2000 as the engine and Access Xp on the user end, and when we look up data it takes a little too long. theres a total of 8833 records plus the all the queries and stored procedure in there also. What would you guys suggest I do??

 

[dbomrrsm]

give us more info so we can help !

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[Catadmin]

How long is "too slow"? What are you comparing "too slow" to in your determination? What are the connection types you are using (SQL Client Tools or 3rd party app via ODBC)? Is everyone in the same subnet/network setup or are these connections remote?

Is it the SQL Part or the Access part that is slow? Have you run SQL Profiler on the SQL Server to see if there is a particular query slowing things down? Have you verified that you have enough RAM on the PC to run your Access XP (from past experience, I'd recommend 512MB Ram, but that was in regards to an Access DB for a specific 3rd party program, so you'll need to check what your requirements are before taking this as gospel)?

Have you verified there is nothing else slow on the network that could be causing this problem?

As Dbomrrsm said, more detail would be helpful.



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[desireemm]

Ok nevermind guys sorry about that its not the entire database its just one form. sorry my bad thanks anyways