SQL Server performance of copied database -
i encountered problems sql server performance.
i have daily process using 15gb size database. i'm executing lot of scripts.
the thing is, first step copy original database, , work on copy. , surprising me, queries on copy executing few times slower on original one.
i'm not expert in databases, don't know might reason.
to compare:
query "a" took:
- 50 seconds on original database
- 600 seconds on copied database
thank interest, dejvid
Comments
Post a Comment