September 6, 2012 at 12:41 am
Hi Experts,
I just wanted to know which tab I need to select in the profiler so that I can capture the data entered into the specific database as my goal is to determine how many accounts we can upload into the db with over a given amount of time, we have roughly 1million accounts to import.
Please let me know what are the counters or tabs need to choose in the SQL Profiler and at the same time I need to check the performance of the server as well as Database when we run the query to dump some data. So, can get the results in profiler or do I need to run perfmon and choose the required counters.
Please let me know which one I can go with and what I need to choose in the tabs. Its on a single database on a single server.
Thank you all in Advance
September 6, 2012 at 1:59 am
Hello,
1 millon accounts means how many records and in how many tables?
Regards
Durai Nagarajan
September 6, 2012 at 2:12 am
Hi,
Its into 2-3 tables in a single database and the data will be like user account with there information.
September 6, 2012 at 2:54 am
use profiler
under TSQL select SQL:batchcompleted and SQL:stmtcompleted to find the reads,writes and time taken.
just run execution plan and see CPU time also.
is it is a fresh table then do think your query will take time, how are you going to upload it.
Regards
Durai Nagarajan
September 6, 2012 at 3:15 am
Hi Nagarajan,
Thank you for your valuable suggestions, I will work accordingly and we are going to dump the data by running some batch scripts.
And one more thing is can we find the performance of the server in Profiler while running the batch scripts. if so which tab we need to use, else we can check in Perfmon tool for the performance of the server.
September 6, 2012 at 3:26 am
If it helps, you can set up a custom counter in performance monitor to return the number of rows in each of the tables you are interested in.
John
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply