Reporting services is already started. There are some reports running on scheduled basis also

Hi Jeff,

The report is now taking more than 12 hr.

The report is executing one SP. The SP initially when tested 2 months it took around 10min to execute from SSMS....

Hi,

Actually we create a Sql Job on scheduled basis to run that SSIS Package everyday.

The job is failing and just giving the script task where it failed but not giving...

Hi All,

We are also in the process of migrating to Sql 2014 and setting up always on.

We are concerning about the normal full backup on Alwayson.

Correct me if I am...

I can provide this details after some time.

I do have one doubt to clarify. We have a report subscribed for one time run but when I check the subscriptions the...

The reports are taking long time. Once I restart the server, the report time come down. The report is using the default parameters for the sp. After the restart it...

It is working by using this

SELECT * FROM sys.fn_get_audit_file ('\\serverName\Audit\HIPPA_AUDIT.sqlaudit',default,default);

GO

Ok. Thank you

Thanks Gila Monster.

I have just two more doubts to clarify.

I think it is possible, If there are 2 SQL Instances (Replicas) running on the same node, can they being part...

Yes. You are right but they are very interested in availability group replicas ( Read only copies).

Here I have one doubt about the availability groups.

Is it possible to have AG created across multiple domains?

Is it possible to have AGs created across VMs on same physical...

Yes but now it is hitting the production database performance (OLTP). That is the reason they want the read only copy for the reporting source

Thanks for the replies.

Yes, they are ready for the budget. They want 3 replicas for some other purpose also. One is specially for reports.

Some how now just one simple report...

Thanks John.

My intention is ServerA login on machine A is accessing data from Server B on machine B.

I know they created linked server for Server A and Server B but...

Thanks All,

They change the mind. They just need to create view with same requirement. All sensitive data to be masked with creation of view.