.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

TcpIpTimedWaitDelay recommendations

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :SharePoint
 
Is there any best practice or any recommended value to set for "TcpIpTimedWaitDelay" in a SharePoint 2007 farm (heavily used farm) ? Or is this value very specific to each SharePoint environment? If so, is there a better way to determine this value? I tried the command "netstat -t" and noticed that there are lot of connections in  "TIME_WAIT" state consuming memory... and the current value set in "TcpIpTimedWaitDelay" reg entry is "4294967295 (decimal)"... I guess this is default value in Win2k8 server... I read couple of articles and just wanted to understand what is the value other people have set in their farms... Any suggestions or help is much appreciated. Thanks, Charan


View Complete Post


More Related Resource Links

Training Recommendations

  
I'm looking for some feedback on SQL 2005 or 2008 training. I am a beginner and have had little hands on experiance with SQL.  The training I'm looking for would deal more with the administrative side and not programing.  Are there books out there that you would recommend to get someone strarted with SQL or maybe a training course, Online or DVD?  Much of the training material I've looked at assumes that you have a basic understanding of the fundamentals of SQL and that's basicly what I'm trying to learn. Thanks in advance. Ken  

Recommendations for writing and debugging SQL?

  
I've been working on writing TSQL code for several years now and I still don't seem to be able to set up a good environment for writing and debugging stored procedures. Currently, I create .sql files for each stored procedure that I'm working on, which might look like this: USE [DatabaseX] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.Routines WHERE Routine_Name = 'p_proc1') EXEC('CREATE PROCEDURE dbo.p_proc1 AS SELECT 1') GO   ALTER PROCEDURE [dbo].[p_proc1] AS BEGIN ..... END GO I add these as solution items in VS 2008, and then go through an iterative process of: Edit Execute Run sp with parameters to test If there are issues, attempt to step through them by running them through ServerExplorer Sometimes I put multiple stored procedures and or DML statements in a single file so when I'm ready to roll out to production, I can just hand the script which I've been running in development to get deployed into production. Here are some of the problems that I run into: 1) I can't always step through the code because I'll get errors like: @param1: this input parameter cannot be converted This happens if the parameter is of type bit, or some other type which you cannot enter as a value into the "Run Stored Procedure" window 2) Running an alter statement against a stored procedure returns error: Msg 1

SharePoint Anti-Virus recommendations

  

Hello,

I'd like to hear which application-level anti-virus products you have found work well with SharePoint 2010 and SharePoint 2007.

Thanks for your input,

Robert


Sharepoint 2010 Best Practice Recommendations

  

I've made a few Sharepoint installations and solutions in my time and have been toying with the new 2010 iteration in my spare time on my super powerful quad-core laptop in a couple virtual spaces.  I recently come across a request from a colleague who asked me a question on which is the most recommended MOSS - SP2010 configuration - single server or separate SQL box and SP Box.  I replied with the non-committal "It depends on what you want to do" generality.  But, it got me thinking...

I've always recommended to my clients to separate the database from the front-end application with earlier SP versions and SQL Server instances.  I also tend to stay away from the smaller SMB crowd...

This was before there was anything like the Express editions of things. 

I'm thinking about a small Mom-n-Pop organization who have say 10 or so employees and has something like a publishing business or a non-profit organization with a magazine or something where they have a terabyte or so of archived scanned documents or a library of a sort along with some third-party hosted open-sourced CMS for a public web "storefront" (think Drupal or some other LAMP/WAMP) as well as some business forms needing a little automation where a workflow solution would be a godsend in streamlining some business processes.  Most organizatio

seeking recommendations for running Visual Web Developer 2010 on Windows 7 without local administrat

  

All -

Please help.

I am seeking recommendations for running Visual Web Developer 2010 on Windows 7 without local administrator access.

Is there a "how to" somewhere that delineates the issues, etc, that come along with 

Is there some other access level, something higher than Power User but lower than Local Administrator, that can be used or created?

There seems to be a lot of places where glitches appear if one is trying to do development on a Windows 7 64 bit box with Visual Web Developer 2010 Express.

For example, without local administrator access, one cannot create a virtual directory in Windows 7 in IIS, which slows down testing, etc.

I am of the mind that developers should be allowed to run as Local Administrators, for expediency sake, etc.

What do you recommend to approach the situation if one must run at a user level lower than Local Administrator?

If you do not run as a Local Administrator when you develop at you corporate environment, then how do you workaround the matter?

If you do run as a Local Administrator when you develop at you corporate environment, then how did you get management to understand?

Please advise.

Thank you.

- Mark Kamoski

 


Cannot get recommendations after querying an association rules model for multiple customers

  
To carry out this data mining task, I am using the Data Mining(DM) add-in of Excel 2007, 
where one has to make use of SQL Analysis Server in order to utilize the add-in.
Basically, I have a three-column dataset: CustomerID,Product,Transaction. These are the steps I am following:
1. Build an Association Rules(AR) Model.
2. Query the AR Model with new data and obtain a recommended product.
Right now, if I supply an input of Products "A","B","C" for "Customer1" I get the recommendation e.g. product "D".
This is the DMX query I am using:
##############################################################################################################
SELECT
PredictAssociation([Associate ProductNo].[ProductNo_Table],INCLUDE_STATISTICS,5) AS [Output 1]  
FROM
[Associate ItemNo]
NATURAL PREDICTION JOIN SHAPE
{@InputRowset } APPEND ( { @InputRowset1 } RELATE [SessionNo] TO [SessionNo] ) AS [ProductNo_Table] AS
InputRowset = Microsoft.SqlServer.DataMining.Office.Excel.ExcelDataReader
InputRowset1 = Microsoft.SqlServer.Data
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend