March 15, 2010 at 4:20 pm
GilaMonster (3/15/2010)
GTR (3/15/2010)
GilaMonster (3/15/2010)
GTR (3/15/2010)
GilaMonster (3/15/2010)
So every single SQL Server instance in existence has an application server running IIS?Not necessarily, most of them do.
Really? Do you have any reference or proof to that end? Or is that just an opinion of yours?
I am not telling SQL server machine has IIS application running on the same machine.
Since when is IIS needed for SQL Server?
Because, if application users are try to make connection to database servers through application while performing upgrade for databases servers users receive error they cannot connect, and ton of emails saying cannot make connection to database servers, we want avoid that situation by disabling IIS, because we have that flexibility to disable IIS.
March 15, 2010 at 4:27 pm
GTR (3/15/2010)
Because, if application users are try to make connection to database servers through application while performing upgrade for databases servers users receive error they cannot connect, and ton of emails saying cannot make connection to database servers, we want avoid that situation by disabling IIS, because we have that flexibility to disable IIS.
Disabling IIS will generate just as many phone calls and email.
Just leave IIS running and display a friendly reminder to the user that services are down for x period of time.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 4:31 pm
CirquedeSQLeil (3/15/2010)
GTR (3/15/2010)
Because, if application users are try to make connection to database servers through application while performing upgrade for databases servers users receive error they cannot connect, and ton of emails saying cannot make connection to database servers, we want avoid that situation by disabling IIS, because we have that flexibility to disable IIS.
Disabling IIS will generate just as many phone calls and email.
Just leave IIS running and display a friendly reminder to the user that services are down for x period of time.
Ok, that worked for us, may be not for everyone. It may be different for different environment. Anyhow it is the time to hit the road, will check latter tonight.:hehe:
March 15, 2010 at 5:05 pm
GTR (3/15/2010)
Alvin Ramard (3/15/2010)
GTR (3/15/2010)
GilaMonster (3/15/2010)
GTR (3/15/2010)
GilaMonster (3/15/2010)
So every single SQL Server instance in existence has an application server running IIS?Not necessarily, most of them do.
Really? Do you have any reference or proof to that end? Or is that just an opinion of yours?
I am not telling SQL server machine has IIS application running on the same machine.
So what are you telling?
Did you consider the implications of have applications servers that are also used for other purposes? What would disabling IIS do to those? Don't come suggesting that in my workplace!
Ok, we have only dedicated application servers for business critical database server, I mentioned it in general. May be in your work place your Server Team might Disable IIS on application servers even though they are hosting multiple applications for database migration, not everywhere:-P
Please don't give advice that is specific to YOUR situation. The original poster may not have a simialr arrangement.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
March 16, 2010 at 1:53 am
GTR (3/15/2010)
GilaMonster (3/15/2010)
GTR (3/15/2010)
GilaMonster (3/15/2010)
GTR (3/15/2010)
GilaMonster (3/15/2010)
So every single SQL Server instance in existence has an application server running IIS?Not necessarily, most of them do.
Really? Do you have any reference or proof to that end? Or is that just an opinion of yours?
I am not telling SQL server machine has IIS application running on the same machine.
Since when is IIS needed for SQL Server?
Because, if application users are try to make connection to database servers through application while performing upgrade for databases servers users receive error they cannot connect, and ton of emails saying cannot make connection to database servers, we want avoid that situation by disabling IIS, because we have that flexibility to disable IIS.
You missed my point.
Not all apps use IIS. Web applications that use the MS stack do, client-server (thick client/smart client) apps do not. Apps also be using things like Apache, WebSphere or other application servers to connect to the DB.
At my last job, we used thick client. There was no IIS, there was no application server. It was a 2-tier design. Application, database.
The IIS advice is specific to your environment. It is not a general piece of advice.
You can't give advice that is specific to one environment as general advice for everyone. Not everyone has applications servers at all, let alone running IIS. Not everyone has replication set up on their server.
When you're giving general advice (ie you know nothing of the specific setup), give general advice that it relevant everywhere, not advice that relates to your specific environment.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2010 at 7:08 am
CirquedeSQLeil (3/15/2010)
Disabling IIS will generate just as many phone calls and email.
Just leave IIS running and display a friendly reminder to the user that services are down for x period of time.
For us it would generate lots more phone calls. Our client base wants to know something, not simply a broken connection as that is when the calls will begin - heaven help the helpdesk folks!. A friendly page, as Jason stated, at least lets the user know work is being done on the site and will be offline for a certain period of time. You need to manage client expectations appropriately, as for many companies that's where the money is made. No money, no job.
-- You can't be late until you show up.
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply