Kris-155042 (3/12/2014)

---

Thanks for your help, but as I said earlier I'm a newbie with RS. Can you tell me what you exactly what you mean. Where do I go? I'm...

You are welcome Oracle_91 🙂

--

SQLBuddy

Kris-155042 (3/12/2014)

---

Yep, and tested the connection successfully. Sorry to be a pain, I'm a newbie to Reporting services.

I've also played around with removing that auto number and reset to point...

Are you the Admin on the Report Server or just a user of SSRS ?

--

SQLBuddy

You can use Profiler Replay to do this. Starting 2012 you can use distributed replay to have a better scalable solution.

Check these ..

http://sqlmag.com/database-performance-tuning/sql-servers-trace-and-replay-tool

http://blogs.msdn.com/b/mssqlisv/archive/2008/06/26/use-sql-server-replay-tools-to-reproduce-and-resolve-customer-issues.aspx

http://technet.microsoft.com/en-us/library/ms189604(v=sql.100).aspx

--

SQLBuddy

You can control this by ordering the replicas in the Availability Replicas section. You needn't change it in the Failover Cluster Manager. For ordering you have to change the mode...

Nice to know that 🙂

--

SQLBuddy

You are welcome, Jelias 🙂

--

SQLBuddy

mario17 (3/11/2014)

---

Yes, Ruser able to follow my link and has error like standard missing permission:

User 'RUser' does not have required permissions. Verify that sufficient permissions have been granted and...

PHXHoward (3/10/2014)

---

Thanks for the article on how it works SQLBuddy. It looks like it just isn't possible to have more than 2 replicas set in auto failover mode. ...

jelias 69485 (3/11/2014)

---

Hi, it's a 64 bits system, Windows Server 2008 R2 SP1.

The memory settings are Min memory = 4Gb, Max Memory = 7Gb.

Index rebuild is done every day. The...

1. It's better to that. That way you can offload your SQL instances and administration becomes less complex.

http://technet.microsoft.com/en-us/library/hh231721.aspx

2. Do a new install on the new server and move the DBs....

Why do they want to access your local server ? You can just grant them access to Report Manager to develop\deploy reports.

--

SQLBuddy

Grant Fritchey (3/11/2014)

---

Let's also be careful about parallelism. It's a good thing. It's just that some queries are set as parallel that shouldn't be. Adjusting the cost threshold for parallelism...

Check if Parallelism is enabled .. Rt Click on SQL Server --> Properties --> Advanced --> Max Degree of Parallelism...