we have SQL Server 2008 (Std edition) installed in my machine.
we have 2 GB of RAM in my machine
we have 100 of Databases on it.
In one of the database, I'm using a query which having 3 tables joined on it.
This query already been written in proper way!. Already reviewed by our seniors...
This query executing in "7 seconds" sometimes... and The same query takes more than "2.5 Minutes" to complete the executing... But, the final result is only 50 to 60 records
Each table have less than 1 million records on it...
1. what would be the reason to take these much of time variations...?
2. what are the ways to identify root cause...?
I already have discussed with my seniors...
and, I'm expecting more reasons/explanations regarding this! instead of reading/passing other Links
Experts! Kindly explain with monitoring scripts in SQL Server itself!
thanks in advance for your valuable reply and explanation!