We are running a Sharepoint WSS 3.0 Server with a full SQL 2005 version, on a single Windows 2003 Standard server. with 2GB RAM.
We have a file upload limit of 100MB. I have been asked to look into increasing the file limit to the maximum that the SQL will allow. (2GB)
I have read the papers and seen the notes on how to do it. Such as the notes on the changes that needed to be done for the IIS and timeout, That is all well and good and the theory is great, has anyone done this and what issues have they ran into?
What I would like to see and hear is had anyone done this. What has their experiences been like for performance and user experience for the users, as well as the Server and the SQL?