We can estimate the resources using DMV's, also if you have access to Idera's SQL diagnostic manager v7.5 you can generate reports on expected database growth, expected resources.
There are few DMV's thru which we can estimate. Also, if you have Idera's SQL diagnostic manager you have the facility to estimate database growth, resources.
Restore the database to a test server (not to the same server that the database already exists); extract the stored procedure code and permissions on the stored procedure; put the...