Thanks Thom..!

we are using reporting services in a application. means - we have added the Reporting services URL in App - Web.config file. In that scenario how to provide the local...

Not a domain it's just a workgroup I have tried adding the Computername\Username and it says The user or groupname is not recognized..!

Both the systems are in WORKGOUP domain..!

Is there any troubleshooting technique guides on this search?

We are running in SQL SERVER 2008R2 , Is there any better solutions in SQL 2012 or SQL 2014 versions?

Regards,

Ram

If we are not running the data purge script, then the server is too slow and affecting the performance as well.

Regards,

Ram

We need to restart the job execution If there is any data changes or deletion.

Regards,

Ram

We need to something to do with having a stored procedure that someone could execute that could create a new database on the instance?

Thanks for your response. After creating the Indexes on column level now report generates with in 2 minutes.

Regards,

Ram

Thanks for your reply. We have table that has 31 million records. Report service will commnunicate with database table and has to display the data.

We have storeprocedure to filter the...

Yes we tried in management studio and it tooks 30 minutes to pull out the report.Actually this is production environment and was working fine last week. suddenly we are facing...

We have database table - audit trail ,this table has 31 million records . We have query with condition to retrieve the records. Is there any better way to get...

Thanks for your help! Is there any other cause for this problem?

We first cleaned up the transaction logs - 20 days back and restored the encryption keys recently - 2 days before.

Regards,

Ram