i have two environments prod and test, both are just replica.
when i try to generate reports on test it is generating fine in 5 min and when i try to generate the same on the prod, it is not getting generated and showing as timed out.
can any one help me how to fix this issue. nothing is mentioned the logs and for information, the test environment is having more data than prod.i check with dbcc showcontig, it is showing 100%.
my sql server version is 2008.
please provide me a solution