June 11, 2007 at 12:02 pm
Hi Exports
My Database performance is very slow last two days back using logshipping transfer the database from one server to another server, on that it is good.
But today only my database performance is slow how to increse my database performance plz guide, where i will cheacked
How to increase the performance of DATA BASE
what are steps we have follow in this situvastion.
June 11, 2007 at 2:15 pm
There are WAY TOO many things that could cause slowness. You don't give enough information for us to really help you.
What was happening on the Server?
-were any applications in use?
-do the Windows Event Viewer logs show any error messages that could show what happened?
What was happening with the databases?
-what jobs were running?
-were any running longer than normal?
-any database maintenance occuring?
-does the SQL Server Error log show anything?
You could be having hardware problems, network problems, who knows what else.
-SQLBill
June 16, 2007 at 10:19 am
Hi,
i facing this problem. because i am using Auto shrink option in DB Property.
so if you are using that Auto shrink property.DB will be come slow.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply