Monday, March 11, 2013 2:45 PM
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 ?
Monday, March 11, 2013 10:51 PM
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.
Saturday, March 16, 2013 7:20 PM
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.
Phaneendra Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, March 18, 2013 2:46 AM