Most of what you are describing are performance related considerations.

Less resources may not be a bad thing in some cases.

Tuning / load testing would likely be something done in an...

Koen Verbeeck (6/8/2014)

---

Lynn Pettis (6/8/2014)

---

Okay, I really need to step away from this person:

Welsh Corgi (6/8/2014)

---

Lynn Pettis (6/7/2014)

---

Welsh Corgi (6/7/2014)

---

That is sweet. I have the sizes stored in KB's. What...

+2

Also make sure that your email server is not a constraint.

We one had a similar...

Although if that is the case, you also need to understand some of the implications.

Here is a good article [/url]describing some of them if you are unsure.

You may want to...

The account SSRS uses might need to have the share mapped.

Setting up Kerberos would be preferred, then you do not have to deal with running and saving the report.

Leveraging user...

sotn (5/29/2014)

---

Hi,

Actually it is more for performance, we have an 'old' vm at the moment 4 cpu 64gb ram etc. and want to upgrade to Ent edition and many more...

jbarry 87949 (5/29/2014)

---

Thanks for tips. Cannot publish the reports to sharepoint quite yet as we are not ready for security on the report front. There are report templates...

Lots of factors can come into play.

Properly sized and setup, virtual is very comparable to physical, plus has some better recovery options.

Baselining and testing is the only real way to...

The Event Log may have some slues.

And if the server has performance counters being captured, you may have some more information to look at.

Koen Verbeeck (5/29/2014)

---

ps_vbdev (5/29/2014)

---

Thanks Koen

How do you know what and when something should be in the dim tables or fact, this is what im find hard as just starting...

Why not publish the report to SharePoint directly?

Check this link out.

SQL User has no network rights.

Is what is in the Excel sheet something that can be imported and stored in SQL Server?

And did you ever contact the vendor?

That would be...

+1

It needs to generate all the data and render it for...

You might want to see if the vendor has any suggestions.

We setup Kerberos, which picks up the Windows User and impersonates across servers.

Generally, most dashboards need security to the logged...

Cubes create distinct counts as part of the build process.

But unless you plan on using more functionality (measures and dimensions), seems like overkill.

Yet another toolset, query language, and process to...