I have identical two database one is slow and one fast both are cleaned database.
The databases had data and i used this query to clean the tables
DELETE FROM tablename
DBCC CHECKIDENT (tablename, RESEED, 0)
I have used this query to clean every table with one database the other database im not sure if i used this query with all table or sometimes used TRUNCATE table
I want someone who are able to find why one of them are slow and fix it.
I will show you both databases when i restore them from bak file.
You will use anydesk to access to my computer to show you the problem.
51 freelancer chào giá trung bình$146 cho công việc này
Hello, I am an expert in Database and have worked on lots of database fixing their performance and currently have worked on fixing a MySQL database for performance and have been able to reduce the load from 95% to 40%
When you say database is slow, Is that mean when you run same query on different database, then you see clear difference in their execution time? Are they both on same DB server? I will be happy to take a look