Post reply

Profiler or Perfmon to get the amount of data loaded into db

  • September 6, 2012 at 12:41 am

    #261571

    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

    #1534283

    Hello,

    1 millon accounts means how many records and in how many tables?

    Regards
    Durai Nagarajan

  • September 6, 2012 at 2:12 am

    #1534288

    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

    #1534311

    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

    #1534322

    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

    #1534326

    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