DataBase performance issue
-
Hi, I have a database on webserver, when some one gives any order from website then data comes into this database. Now i'm fetching these data from websercer to our local machin's dataabse. for this purpose i'm using en exe which contains stored procedure for fetching the data. These stored procedures takes 5-7 min to fetch the data from webserver. Now the problem is that at the time of execution of stored procedure no one can give the online order because of database busy. My question is that how i can improve the system so that one can give online order at the time of execution of stored procedure. Thank you..
krishna veer singh
-
Hi, I have a database on webserver, when some one gives any order from website then data comes into this database. Now i'm fetching these data from websercer to our local machin's dataabse. for this purpose i'm using en exe which contains stored procedure for fetching the data. These stored procedures takes 5-7 min to fetch the data from webserver. Now the problem is that at the time of execution of stored procedure no one can give the online order because of database busy. My question is that how i can improve the system so that one can give online order at the time of execution of stored procedure. Thank you..
krishna veer singh
-
can you tell which Database Server are you using and do you have any maintenance plans scheduled.
Best Regards, SOFTDEV If you have knowledge, let others light their candles at it
I'm using sqlserver 2005
krishna veer singh
-
Hi, I have a database on webserver, when some one gives any order from website then data comes into this database. Now i'm fetching these data from websercer to our local machin's dataabse. for this purpose i'm using en exe which contains stored procedure for fetching the data. These stored procedures takes 5-7 min to fetch the data from webserver. Now the problem is that at the time of execution of stored procedure no one can give the online order because of database busy. My question is that how i can improve the system so that one can give online order at the time of execution of stored procedure. Thank you..
krishna veer singh
Not without knowing a lot more about your system - table sizes, indices, configuration, usage, etc etc. One thing you could try, in your stored proc use (nolock) on your reads, this may help
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP
-
Hi, I have a database on webserver, when some one gives any order from website then data comes into this database. Now i'm fetching these data from websercer to our local machin's dataabse. for this purpose i'm using en exe which contains stored procedure for fetching the data. These stored procedures takes 5-7 min to fetch the data from webserver. Now the problem is that at the time of execution of stored procedure no one can give the online order because of database busy. My question is that how i can improve the system so that one can give online order at the time of execution of stored procedure. Thank you..
krishna veer singh
-
Can you show your store procedure statement
Best Regards, SOFTDEV If you have knowledge, let others light their candles at it
In SP there is nothing but only select and insert statements, i mean i'm selecting new data from web sql server and inserting it into our local sqlserver.
krishna veer singh
-
Not without knowing a lot more about your system - table sizes, indices, configuration, usage, etc etc. One thing you could try, in your stored proc use (nolock) on your reads, this may help
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP
No any complex thing is their in my system. only i'm selecting data from web sqlserver table and inserting it in to local sql server tables.
krishna veer singh
-
No any complex thing is their in my system. only i'm selecting data from web sqlserver table and inserting it in to local sql server tables.
krishna veer singh
yes, but I bet there is a where clause, so are those columns indexed? Its far too complex to do in a fotrum without any table defs, index defs, usage stats etc etc. Run your query through query analyser and look at the execution plan, that should at least give you some clues.
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP