Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
performance testing database

คำตอบ performance testing database

  • Monday, March 11, 2013 2:45 PM
     
     
    Sign In to Vote
    1

    Hi,

    I'm doing a project about performance comparison between data models. I already had the databases of those data models and now I have to use SQL query to test performance on those databases. Anyone have any ideas about what type of data I need to make query to test or what kind of queries I need to use ?

     

All Replies

  • Monday, March 11, 2013 10:51 PM
     
     
    Sign In to Vote
    0

    Hi,

    you have to run the application (reports) on top of your database and analyze the performance using sql profiler to analyze the issues. or simply you can run the sql server performance dashboard. dashboard is SQL Server out of the box solution.

    Regards,

    Zaim Raza.

     
  • Saturday, March 16, 2013 7:20 PM
     
     Answered
    Sign In to Vote
    0

    This is actually like testing your database performance. For this, you need to know how data patterns come into your database. Similarly you should load the data manually and execute queries/stored procs which are accessing those models and then check how the performance is where to tune the things.

    Regards,

    Phaneendra Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.