Can you use transactional replication to bring data into scope, but into a different schema where you can add indexes? Know that it is possible to replicate data in one...

The top 5 targets I look at when trying to improve performance are:

1. queries

2. queries

3. queries

4. indexes

5. schema

It sounds like you cannot change any of those.

If by chance you're having...

Duplicate post. Please direct replies here: http://www.sqlservercentral.com/Forums/Topic1273023-146-1.aspx

Please do not cross-post. It fragments replies and wastes peoples time.

SQL Server will deliver results to the client as fast as the client can consume the data. The "client" in this scenario is anything beyond the interface SQL Server is...

Something occurred to me while coooking breakfast...do you need to have the SQL Server Integration Services service running? It is not technically required to run SSIS packages, and in fact,...

troy_hilton (3/27/2012)

---

Thanks for the reply.

These numbers I admit are vague, but this is what I have to work with. My understanding is that SSIS will be used for both data...

As far as scoping your hardware, those user counts are a little out of my league. Will that be the users of SharePoint, or the number sof users potentially directly...

It's fine, as long as we know what it is you're trying to do...so what is it that you're trying to do? What version of SQL Server? And is SSIS...

L' Eomot Inversé (3/26/2012)

---

opc.three (3/26/2012)

---

As a side note, some in the community have gone so far as to say you should enable the option by default on all new instances,...

Are you in the right forum? Are you implementing a new cluster on SQL 2005? Or 2008 R2? Or 2012?

Also, "SSIS Cluster" is kind of a misplaced term as SSIS...

I see, so you're looking for a free version of BizTalk Rules Engine that plugs into SSIS.

I suspect you're looking at a non-trivial custom programming venture. Here is one person...

Brandie Tarvin (3/26/2012)

---

Not really. That last column tells me that...

george sibbald (3/26/2012)

---

If your server is in a stable state of equilibrium you may not need to worry. Do you have 'optimize for adhoc workloads' option enabled? If not, you...

george sibbald (3/26/2012)

---

these are my results on a consolidated SQL server supporting about 10 apps with 13GB out of 16GB assigned to SQL (64bit SQL2008 windows 2008 enterprise)

CacheType ...

Thanks, Lynn. No worries, Brandie. I realize I can get a bit frenetic with my posts at times 😛 I wasn't trying to be pushy about contacting Kim, just saying,...