A very interesting shift has happened over the past year prompting a change in the SharePoint community resulting in an evolving paradigm shift. SharePoint, the fastest revenue generating product in Microsoft’s history (I talk more about that momentum in a recent SharePointForAll welcome post) has a seriously strong and tight community. This started first by common bond among those struggling to deploy and develop the product building up our first generation of MVPs. The evolution has continued this past year in an explosive growth in the community, and a shift into exponential growth while maintaining the close knit community due to 5 things. 1) The broad adoption of major consumer social networks by SharePoint folks connecting thousands of us – blogs, twitter, facebook and a bit of linked in too. 2) Key Microsoft SharePoint community advocates leaving the mothership and integrating into the community 3) SharePoint Saturday – a free no holds barred community event driven primarily by the community for the community (code camps as well) 4) Best Practices Conferences – a non Microsoft conference that brought together the technical and community leaders in a big way like no other 5) SharePoint User Groups – connecting with others with the same challenges in a show and tell manner, providing the local to global connectivity
1 – Social Networking – Twitter – A year ago Lawrence Liu was a lone voice (I know there were others, but just follow my line of thinking) shouting in the darkness praising microblogging and essentially halting his other blogging activities and telling the community to follow him there for the latest and greatest. A few MVPs created accounts, with a handful using them, but the community wasn’t really yet there. It was a start. About 6 months later a few of us took another look at it and found something. The SharePoint community was there, but small. We had to band together and build our little community and make lists to help find each other. The lists really helped us find new faces and new people. Facebook helped us find each other based on who we knew and who we had in common. The blogging networks helped us find what Mike Gannotti was doing with his cool videos. It also made us get a lot more personal with each other for good or worse. We know what each other are doing throughout the day for over a year now. Many blogs were added to the fray over the last year, but I’ve seen the social networks help us continue those conversations and filter through the best content. Many have dropped RSS feed readers over the recommendations of posts and news content via twitter.
2. SharePoint Big (Visible) Names Leave Microsoft – Mike Fitzmaurice, Lawrence Liu, Joel Oleson, Mike Watson – Why did that happen? It didn’t happen for one reason. My perception: It was a non launch year and each of them wanted to spread their wings. Each LOVED SharePoint, each was a major contributor for the community, and each had their own reasons. What resulted was the community realized they couldn’t tie their perspectives and knowledge to one person at Microsoft. It made a lot of people look inward and give more clout to the community, more trust in the user groups, more trust in MVPs and community leads. It made them realize it wasn’t Microsoft or TechNet that would tell them exclusively how to design and use the product, they’d have to figure it out by leveraging the community. Community became very important as this shift would make a difference to all of us in the community. (Understand there are still hundreds of great people working on the product(s). We are well served by Dave Pae, Chris Johnson, Richard Riley, Tom and Arpan. They just don’t have too much to say until SharePoint Conference. 😉
3. SharePoint Saturday – Michael Lotter, Susan Lennon, and Kevin Israel (Team System MVP) the three founders of SharePoint Saturday, none of which are SharePoint MVPs would build an organic following that would make a huge positive impact on the community in the U.S. Affecting nearly all regions, SharePoint Saturday brought 150+ people together at each free event and provided access to experts with choice. Despite your local background you could propose a session and be chosen. The first SharePoint Saturday in Virginia beach brought in speakers from around the U.S. It’s sponsorship from vendors would guarantee it’s success model. Last week’s SharePoint Saturday in D.C. had over 50 speakers at the dinner, and a few had flown in on their own dime (not from SPSDC) from Georgia, North Carolina, New York, Seattle, Texas, and San Francisco. The locals could get high quality end user content, admin, and developer content across multiple tracks. It was the speaker lists and the speaker dinners and comradare that would have its influence on the community. The twittering made everyone feel like they were there. MVPs and other speakers at the conferences had built their names and reputations from their blogs and on twitter. Every SharePoint Saturday was a mini reunion and gathering of the SharePoint minds. http://www.sharepointsaturday.org
4. Best Practices Conference – Ben Curry and Steve Smith drove for a conference that would not be political, it would not be about getting the regular TechEd Micrsoft speaker list, but would break the trend and go after those in the community who knew. Sure it was a paid conference, but Ben and Steve took it as their responsibility to track down those in the community that were recognized as having something that people wanted to hear. The emphasis wasn’t on the speaker skills, but on the knowledge of the individual. In our community it’s great if you can get 10 top notch speakers at an event, but both Ben and Steve were looking at 50-60 of the top speakers and talent in our community and it made a difference. These events had impact on the community by helping establish the community and providing them the platform to share their knowledge. While Microsoft was invited, these conferences were primarily driven by the community for the community with the knowledge of the SharePoint social network by Ben and Steve. There’s another one coming up in DC in August. http://www.sharepointbestpractices.com
5. SPUGs – SharePoint Usergroups – SharePoint Usergroups can now be found on every populated continent and Michael Noel have discussed efforts for Antarctica. In my travels I’ve visited Usergroups and communities around the world and one thing I’ve found in common is the thirst for knowledge and the thirst for community and collaboration. These people need answers, they feel like they are alone, and they light up when they find someone who knows their struggles. The SharePoint community exists globally and locally. That’s the exciting part. The SharePoint Saturday has brought it local and elevated the locals in the community and united them with the national and global SharePoint community. Everyone has a voice and everyone has a right to be heard. Their ideas are just as important to be heard and considered as the next persons. The ISPA at http://www.sharepointpros.org was established to help promote the community.
So where are we?
This paradigm shift has taken the focus of the expertise of the product group the exclusive voice on the product. As well it’s landed on the MVPs and SharePoint community leadership. I don’t know how best to describe this community leadership bucket, but if you spend sometime both in the blogs and on twitter you’ll surely find it. There are a lot of good people in the SharePoint product group and we hope to hear from them in November, but I think they’ll realize we’ve all changed. This 2010 SharePoint wave is going to be different this time around due to our integration with the social networks and the tight knit community. Expect to find a lot more sharing and a lot more community. We’ve evolved.
That’s the amazing part. We are really getting to know not just a handful of people. We are all essentially getting to know and conversing with hundreds and some of us thousands. It’s amazing. Wild thing is this shift toward a broader base and the more distributed voice with real personality will continue.
In the last month I’ve had a few design sessions and conversations where more than just WSS and SharePoint Server are involved in the deployment. In one customer it was wild… MS CRM, Performance Point, and Project Server plus the normal MOSS stack. They were going to do it all in one farm with a bunch of app servers and even add a SQL Reporting server and SQL Analysis server. It gave me a headache looking at their diagram.
In an hour I had them with the same amount of production hardware, but in 4 farms. SQL on the backend for storage was changed hardly at all. I also added a more robust virtual dev and test environment to mimic the new designs. Was pretty sad. <Update> Reporting Services with SharePoint Integrated mode is much better and has good deployment guidance on TechNet at Deplyment Planning for Reporting Services with SharePoint Integrated Mode which includes high availability solutions.</update>
Why so many farms? Can’t project server live with MOSS?
7 Reasons I don’t install Project Server on SharePoint Server
1. The SharePoint database rules and Projects reporting capabilities and flexibility (history) – I’ve achitected, administered, and troubleshoot Project Server off and on since 2002. The expectations around installing funky service packs and running analysis cubes and massaging the database and connectivity has a history with me. I’ve had cool aid conversations around list scalability and the project databases with the project team. They are drinking more cool aid than they use to, and the uptake of Project as a commodity has REALLY come a long way.
2. Service Pack and Integration testing (perceived?) – Around RTM I was working with Boris on the project TPM side who spent years in Europe on Project 2003. He was just down the hall. We’d have long conversations around templates, integration, and even spent time together talking about lists, GUIDs, and web app challenges. The service pack testing and integration was one where I saw obviously the WSS integration testing, but the time spent on cross testing with MOSS seemed to come late. There likely is some cross testing with MOSS, but this is where I start to get nervous about environments. There’s a lot of test cases that will never make it in. Don’t expect the SharePoint Server team to do cross testing with Project Server, and the Project team, what are they testing? They are testing their bread and butter. You know where I’m going. Every service pack there is complexity around order of patching and what includes what.
3. If you’re on MOSS and you add Project Server it’s not much of a Lights on (It is the other way) – Many people would expect wow I’ll get all the project stuff that I can now integrate with my SharePoint collaboration sites. Those project templated sites can be just as easily accessed from another farms with the data viewer web parts. That Project template is nice, but does it really add what anything you need to your collaboration sites? You tell me. Love to hear responses to this. I don’t see how you couldn’t get the same with a cleaner admin experience having it on a different farm. (I can see getting the auditing, workflows, and web publishing features to light up if you were planning projects.)
4. Performance Footprint – Project is quite intense with it’s query and analysis structure. I would suggest keeping those databases on different physical drives while I think sharing the high availability SQL environment is fine in most cases.
5. Portal GUID issues – Do some research on site to site migrations and disaster recovery with Project server and you’ll find it is actually a different kind of app. They have some unique challenges and run some unique STSADM commands. This next level of troubleshooting is one where you really may want to limit the exposure.
6. Future Upgrade challenges – Ok, so you’ve been running Project Server 2007 and MOSS 2007 for years and now you’re ready to go to 2010. Hmmm. Now complexity is really exacerbated (extreme). Do I need to say more? Those using project have these timelines and the collab people are ready for the platform yesterday to take advantage of X and Y.
7. Specialty Expertise – Try finding a the UBER Architect/consultant who can do EPM Enterprise Project Server and SharePoint Server. You thought the SharePoint guys bill rates were high. HA! (Now add the CRM, and Performance Point requirements to your project and try to find someone… Talk about jack of all trades and expert of none. Sorry wild crazy consultant guy who doesn’t sleep. You do rock! …but we all know you don’t have availability ‘cause you don’t even twitter and share your integration experience.)
Having had experience working with the project server team for the last 5 maybe 6 years. My history tells me they aren’t drinking the full SharePoint list cool aid. They’ve come a LONG way. I give them a ton of credit. From where they were in project central and in that whole evolution. It’s this history that teaches me a lesson of their evolution of their database structure and analysis and comfort level of publishing schemas and encouraging people to do reporting on the databases. It’s a different world despite the fact the great hooks built on WSS. The middleware integration around features isn’t as mature as you’d expect. The idea of features is awesome and if you find something that you need, it likely isn’t that much of a challenge to track down that piece of functionality and get it over to your collab environment. I worked on a hosted design of project server with a contractor back in the 2003 days. I installed a service pack on that environment and had to run a batch script over a hundred times (we were hosting one of the largest project server hosted deployment with over 100 databases). My time in the trenches troubleshooting the connectivity to the “orgs” that we were hosting on project server had a different sort of middleware feel to it. I’m happy to see them come to the commodity hosting game and take advantage of SharePoint scale and ease of supportability from where they’ve been.
One consideration is not what Project brings to MOSS, but the other way around. What does MOSS bring to Project Server? Maybe that’s a better way to look at it, and actually might be the route still of getting say auditing and deeper workflows and ECM on your Project sites. Still you might want to keep your collab and other portals separate. I came across a BDC project on Codeplex to pull in data from Project Server. You could do that with 2 farms or not.
What about performance point? The argument isn’t as clean, but yes I’d recommend the same until the next version. Usually a performance point box doesn’t need high availability, but could definitely get away with virtual servers.
What about Reporting Services SharePoint mode? Definitely separate for HA. If not HA then if you’ll never be HA, then ok, you can keep them together. That’s for the smallish environments.
Other dynamics applications? Today – keep ‘em separated.
Isn’t this all contrary to the Small Biz Server Mentality – Yes. I’m not a fan of the Exchange/DC/SharePoint all in one. I think it’s crazy. Definitely crazy now that we have virtual server technology. No reason to mix these things. Put ‘em all on the same host sure, but keep ‘em separated.
That’s my story and I’m sticking to it. Ask me again in 2010. What’s your story!!??
Oh by the way… Is it support to run these together? Yep. Here’s the articles on TechNet that prove the answer is yes.
Deploy Office Project Server 2007 with Office SharePoint Server 2007
Deploy Office SharePoint Server 2007 to an existing deployment of Project Server 2007
Deploy Office SharePoint Server 2007 and Office Project Server 2007 to a new environment
Apparently Christophe (The MAN on Project) did a talk on the better together story in Barcelona. I hope he’s not mad at me for this post. Deploying Project Server 2007 in an Existing SharePoint Server 2007 Farm. No hard feelings Christophe, I’m happy to talk about SharePoint at your Project Conferences any time.
I find that Nilesh says it was “interesting and a real challenge to implement” in reference to a MOSS and Project install experience.
Reading through blogs on the topic to find some nuggets I love this question. Brian Smith from Project Server’s Product Support’s answer makes is sound so easy. Thanks Brian.
# re: Project Server 2007: Deploying Cumulative Updates
we have an environment where initially WSS and MOSS have been implemented and patched to IU, then Proj Svr installed + SP1 (Office Svrs IU can not be run 2nd time) Which Feb CU patch should we use?
You need both the WSS (961755) one and the MOSS Server one (961756) – this will cover for WSS, MOSS and Project Server. Brian.
Brian’s latest post on failures in step 8 of config wizard helps to bring out the scariness of wierdness in patching.
SHayden did a scary blog on “Forcing uninstallation of Project Server 2007 or MOSS 2007” (He rebooted to early and couldn’t even run psconfig?)
As the world of SharePoint grows so do the characters and personalities in the game. A recent tweet from Dan Lewis, a great SharePointer that I met at SharePoint Saturday Virginia Beach which included a reference to a SharePoint comic. Little did I know he had a an series of them. After reading ALL OF THEM and ROTFL and many LOLs… I was anxious to help him promote his work and volunteered to host a Cartoon if he’d make one for me.
Without further ado…
by Dan Lewis
If you have been following me in the U.S. this past week you would be ROTFL (rolling on the floor laughing.) If not you’d wonder what’s so funny? Last week I came back from a crazy 3 week tour across Florida, Europe, and even frickin (excuse my French) Egypt! (Egypt is awesome, I HIGHLY recommend it!) As I was flying out of Luxor I was picking up my carry on which was filled with various granite carvings of Ramses and a god of protection for women and children at home, and threw out my back. So while I was recovering I ended up doing a couple of my in person sessions, virtually… including Birmingham Alabama SharePoint User Group and Atlanta SharePoint Saturday. I’m sure it was a surprise for those that were there to hear my voice. Dan says it best in the cartoon above.
Here’s my “10 Steps to Successful Deployment” and “SharePoint Admin Fundamentals” decks if you were at either of those sessions.
Thanks again Dan! Thanks for keeping us smiling. Keep it up!
I was looking at my blog traffic to figure out what countries give me the most love (by visiting my blog) where I haven’t yet had a chance to reciprocate (visit them).
So here’s a break down of recent visits by country with three columns, 1) – percentage of overall traffic, 2) User Group of Conference Visit (ever) 3) A visit that could have been vacation
Essentially I want to see the world and a lot of the world wants to see me, so why not???
The most surprising is how I’ve been neglecting India and had been neglecting the UK. I think I need to spend more time with those folks as well. Maybe those once a year Teched/IT Forum events aren’t enough. The best practices Europe in the UK event definitely went off well. I’m definitely interested in your feedback on where you think I should visit.
| Count | Country | Monthly Visits | Percent of Visits | Event | Visited |
| 1 | United States | 24896 | 45.77 | x | 1 |
| 2 | United Kingdom | 4004 | 7.36 | x | 1 |
| 3 | Canada | 2557 | 4.70 | x | 1 |
| 4 | India | 2514 | 4.62 | ||
| 5 | Australia | 2255 | 4.62 | x | 1 |
| 6 | Netherlands | 1792 | 3.29 | x | 1 |
| 7 | Germany | 1722 | 3.17 | x | 1 |
| 8 | France | 953 | 1.75 | 1 | |
| 9 | Belgium | 751 | 1.38 | 1 | |
| 10 | Sweden | 724 | 1.33 | 1 | |
| 11 | Singapore | 698 | 1.28 | 1 | |
| 12 | China | 691 | 1.27 | ||
| 13 | Switzerland | 553 | 1.02 | x | 1 |
| 14 | Denmark | 531 | 0.98 | x | 1 |
| 15 | Spain | 531 | 0.98 | x | 1 |
| 16 | Italy | 522 | 0.96 | 1 | |
| 17 | Ireland | 502 | 0.92 | ||
| 18 | Norway | 407 | 0.75 | ||
| 19 | New Zealand | 367 | 0.67 | x | 1 |
| 20 | Russia | 358 | 0.66 | ||
| 21 | Poland | 353 | 0.65 | ||
| 22 | Finland | 323 | 0.59 | ||
| 23 | South Africa | 307 | 0.56 | ||
| 24 | Brazil | 293 | 0.54 | ||
| 25 | Austria | 280 | 0.52 | 1 | |
| 26 | Egypt | 277 | 0.52 | x | 1 |
| 27 | Malaysia | 269 | 0.52 | x | 1 |
| 28 | Japan | 263 | 0.51 | x | 1 |
| 29 | Israel | 261 | 0.51 | x | 1 |
| 30 | Portugal | 259 | 0.51 | ||
| 31 | Hong Kong | 217 | 0.50 | ||
| 32 | Czech Republic | 210 | 0.50 | 1 | |
| 33 | United Arab Emirates | 200 | 0.50 | x | 1 |
| 34 | Slovenia | 189 | 1 | ||
| 35 | Mexico | 174 | x | 1 | |
| 36 | Turkey | 174 | x | 1 | |
| 37 | Saudi Arabia | 162 | |||
| 38 | Taiwan | 152 | 1 | ||
| 39 | Pakistan | 132 | |||
| 40 | Greece | 124 | |||
| 41 | Thailand | 113 | 1 | ||
| 42 | Vietnam | 109 | |||
| 43 | Romania | 104 | |||
| 44 | Croatia | 101 | 1 | ||
| 45 | Hungary | 98 | 1 | ||
| 46 | Argentina | 96 | |||
| 47 | Philippines | 84 | |||
| 48 | Colombia | 80 | |||
| 49 | Iran | 79 | |||
| 50 | Sri Lanka | 74 | |||
| 51 | South Korea | 67 | 1 | ||
| 52 | Ukraine | 66 | |||
| 53 | Jordan | 65 | x | 1 | |
| 54 | Indonesia | 63 | 1 | ||
| 55 | Serbia | 63 | |||
| 56 | Luxembourg | 60 | 1 | ||
| 57 | Lithuania | 55 | |||
| 58 | Slovakia | 53 | 1 | ||
| 59 | Bulgaria | 52 | |||
| 60 | Kuwait | 51 | 1 | ||
| 61 | Belarus | 46 | |||
| 62 | Lebanon | 46 | |||
| 63 | Panama | 46 | |||
| 64 | Estonia | 43 | |||
| 65 | Qatar | 43 | |||
| 66 | Iraq | 41 | |||
| 67 | Oman | 39 | |||
| 68 | Bahrain | 38 | |||
| 69 | Jersey | 36 | |||
| 70 | Chile | 31 | |||
| 71 | Peru | 31 | |||
| 72 | Latvia | 27 | |||
| 73 | Trinidad and Tobago | 26 | |||
| 74 | Bolivia | 19 | |||
| 75 | Iceland | 19 | |||
| 76 | Sudan | 18 | |||
| 77 | Costa Rica | 17 | |||
| 78 | Dominican Republic | 16 | |||
| 79 | Isle of Man | 16 | |||
| 80 | Moldova | 15 | |||
| 81 | Morocco | 14 | 1 | ||
| 82 | Tunisia | 14 | |||
| 83 | Malta | 13 | |||
| 84 | Uruguay | 13 | |||
| 85 | Cuba | 12 | |||
| 86 | Uganda | 12 | |||
| 87 | Bosnia and Herzegovina | 11 | |||
| 88 | Kazakhstan | 11 | |||
| 89 | Senegal | 11 | |||
| 90 | Bermuda | 10 | |||
| 91 | Puerto Rico | 10 | |||
| 92 | Botswana | 9 | |||
| 93 | Cyprus | 9 | |||
| 94 | Liechtenstein | 9 | |||
| 95 | Nigeria | 9 | |||
| 96 | Guernsey | 8 | |||
| 97 | Jamaica | 8 | |||
| 98 | Macau SAR China | 8 | |||
| 99 | Ecuador | 7 | |||
| 100 | Brunei | 6 | |||
| 101 | Libya | 6 | |||
| 102 | Macedonia | 6 | |||
| 103 | Mauritius | 6 | |||
| 104 | Cayman Islands | 5 | |||
| 105 | El Salvador | 5 | |||
| 106 | Kenya | 5 | |||
| 107 | Venezuela | 5 | |||
| 108 | Zambia | 5 | |||
| 109 | Algeria | 3 | |||
| 110 | Georgia | 3 | |||
| 111 | Ghana | 3 | |||
| 112 | Greenland | 3 | |||
| 113 | Albania | 2 | |||
| 114 | Andorra | 2 | |||
| 115 | Angola | 2 | |||
| 116 | Armenia | 2 | |||
| 117 | Ethiopia | 2 | |||
| 118 | Guam | 2 | |||
| 119 | Guatemala | 2 | |||
| 120 | Ivory Coast | 2 | |||
| 121 | Mongolia | 2 | |||
| 122 | Myanmar | 2 | 1 | ||
| 123 | Namibia | 2 | |||
| 124 | Afghanistan | 1 | |||
| 125 | Bahamas | 1 | |||
| 126 | Cambodia | 1 | 1 | ||
| 127 | Congo – Brazzaville | 1 | |||
| 128 | Faroe Islands | 1 | |||
| 129 | Fiji | 1 | |||
| 130 | Gibraltar | 1 | |||
| 131 | Guyana | 1 | |||
| 132 | Honduras | 1 | |||
| 133 | Lesotho | 1 | |||
| 134 | Martinique | 1 | |||
| 135 | Monaco | 1 | 1 | ||
| 136 | Nepal | 1 | |||
| 137 | Nicaragua | 1 | |||
| 138 | Palestinian Territory | 1 | 1 | ||
| 139 | Papua New Guinea | 1 | |||
| 140 | Reunion | 1 | |||
| 141 | Syria | 1 | |||
| 142 | Togo | 1 | |||
| 143 | U.S. Virgin Islands | 1 | |||
| Total | 54,394 | 40 |
Got this question from a reader…
Q. Is Windows NLB always an option? Or when does it become wise to look into a hardware solution?
Deciding to use NLB or Not…
A. I find NLB very scalable and a simple solution on intranets. I would rarely recommend NLB on an extranet or Internet solution. Why? Not so much because of scalability which ultimately ends up being more of a network bottleneck or NIC bottleneck than a software bottleneck in its load balancing algorithm. The DIP and VIP solution that NLB provides is pretty simple. The intelligence inside of NLB is quite stupid actually. I’m really not a fan of NLB from a pure high availability solution because of it’s lack of understanding of web technologies. There are some enhancements in NLB Windows Server 2008, but not the awareness features I would have liked to have seen around web service detection. What I mean by this is NLB will continue to send users to a server which is up, but the web service is hung, slow, or depreciated in a number of ways. It’s intelligence nearly goes to the level of is the IP up or not.
What about NLB vs. DNS round robin?
It’s almost as bad as DNS round robin where it will simply send users between two systems. The parts where it is better is the flexibility of who manages it. If your server is hung, but you can ping it, NLB and DNS round robin will both continue send users to the system, but if you’re doing maintenance on a system you can simply drainstop connections and monitor usage with perfmon for the w3wc service. With DNS RR you’d have to go into DNS and make the change to pull it out of rotation, and remember to add the entry back in. Most of us wouldn’t have access to both DNS and SharePoint. So the flexibility of the NLB actually living on our boxes makes it easier and more manageable. Think of NLB as more of a manageability and load balancing solution rather than a high availability solution, which is likely a tough stretch for most people.
How is hardware load balancing better or worse
NLB is cheap. Hey, you’ve already paid for the server and the Windows software and NLB is included. If you decide you want hardware load balancing solution, and there are a ton of options out there. You’ll find the cost takes quite a jump based on the solution. With a hardware based solution you should look at all the knobs and the bells and whistles. Now you get various layers of security filtering, you get caching and compression, you get a real high availability solution with very detailed detection based on HTTP error codes or a half dozen other mechanisms that can be used to detect failures or slow responses. Again NLB doesn’t give you added security, caching, compression and we’ve already discussed it is pretty stupid with HTTP. Originally it wasn’t designed for HTTP. It was designed for load balancing various applications and never went to the level of trying to understand the services that it load balances. It’s in the wrong network layer to help us with our application intelligence and would suggest it be configured in a monitoring solution like MOM or system center operations manager. It’s always expected applications to understand it, and hoped that applications would use it’s APIs to stop and start services.
With Hardware load balancing you can control the level of intelligence. You don’t have to look far for credible solutions. Most of your network equipment people have solutions for you… F5 and Cisco are the most popular, but even Microsoft’s IAG and ISA should be considered when you’re looking to provide solutions in the more intelligent space where you are looking at providing a real high availability solution. (While the MS solutions are not hardware or firmware based, you should look at offloading these to separate hardware.) Most people wouldn’t even dedicate the hardware for the SharePoint solution and often these types of devices are already providing solutions in the Internet or Extranet space and quite possibly for the Intranet Portal. When you purchase a solution make sure you’re buying redundancy. If you purchase one device you’re back to the single point of failure.
Q. Is it simply a matter of sessions and activity, or would utilizing Excel Services, Workflow, BDC, etc become a breaking point for NLB?
I have heard of stress tests with NLB vs. Hardware LB solutions, but haven’t been impressed. Every day I see NLB serving very large internal applications and doing just fine. Like I said, it’s usually the NIC or the network that’s the real bottleneck. Running services on the server doesn’t really matter, it’s all just traffic and NLB isn’t cracking open the packets anyway. The decision to go with one or the other should be coming from security requirements, or true high availability requirements, but understand the cost delta. It is quite possible to get 99.9% availability with NLB, but your monitoring team needs to understand NLB and they also need to be 24/7 and your monitoring needs to monitor all the DIPs (dedicated IPs) and VIPs (Virtual IPs) in your farms. Not just the IPs, but the HTTP services requested from the DIPs and VIPs.
Oh, and by the way, SharePoint the application doesn’t care which one you use. That’s up to you.
I’ve done some previous posts on the topic of configuring and troubleshooting NLB