专用IIS和DB服务器上的Lightswitch性能 [英] Lightswitch Performance on dedicated IIS and DB Server
问题描述
任何帮助或评论都将不胜感激……..这就是方案
Any help or comments would really be appreciated…..Here is the scenario
我为潜在的aroung 200用户群的大型组织开发了Lightswitch Silverlight应用程序.它具有附加的SQL DB，并且是在我的旧笔记本电脑上开发的.这是一个简单的应用程序，大约有35张桌子，最复杂的屏幕只有一个主屏幕， 不同选项卡中的4个子表单.它的最终用户数量约为100-150，但从6开始，然后经过验证，将增长到20-30.
I developed a Lightswitch Silverlight application for a large organisation with a porential user base of aroung 200. It has an attached SQL DB and was developed on my old laptop. It is a simple app, about 35 tables, the most complex screen has one master, 4 sub forms in different tabs. Its ultimate user number will be circa 100-150 but starting around 6, then to grow to 20-30 when proven.
在笔记本电脑上飞行，没有延迟或延迟.它已在Azure上进行了用户测试，Azure是免费的网站选项，为Databae提供了Standard-S1-20 DTU选项.在Azure上，尽管规格要求很小，但表现出色，但响应速度却很快.在这两种情况下 初始数据库很小，每个表中只有几条记录.
On the laptop it flew, no lag or latency. It was user tested on Azure, the free web site option with a Standard-S1-20 DTUs option for the databae. On Azure, despite the small specification performance was excellent, sub second responses etc. In both cases a tiny initial database size, only a few records in each table.
对于生产，我们从本地托管公司委托了2台服务器，其中一台专用于IIS，另一台专用于SQL Server.规格如下:
For production we commissioned 2 servers from a local hosting firm, one dedicated to IIS and the other to SQL Server. Specifications are below:
服务器
OS
VLAN
CPU内核
Mem
存储
数据库
Win 2012 R2
Win 2012 R2
是
4
启动
Min
max
2048 mb
1024 mb
8192 mb
C:
S:
D:
I:
100mb
16mb
200mb
100mb
IIS
Win 2012 R2
Win 2012 R2
是
4
启动
Min
max
2048 mb
1024 mb
8192 mb
C:
S:
D:
I:
100mb
16mb
200mb
尽管数据库大小相同，但此配置(只有1个用户)比我的旧笔记本电脑(正在运行的客户端，中间件和服务器)和便宜的Azure慢得多.在笔记本电脑上，天青地保存一项记录需要不到2秒的时间 跳闸，在新配置上最多需要12秒，有时会超时.打开一条记录大约需要5秒钟.
Despite the same tiny database size this configuration is significantly slower (with 1 user) than my old laptop (running client, middleware and server) and the cheap Azure. On the laptop and azure saving one record take less than 2 seconds for the round trip, on the new config it takes up to 12 seconds and sometimes times out. Opening one record takes circa 5 seconds.
这家托管公司无法解释并建议它达到最佳状态，他们已经检查了磁盘速度，网络速度等.我无法想象两个专用服务器比一个慢的情况会如何.旧笔记本电脑和便宜的Azure配置.
The hosting firm is unable to explain and suggests that this is as good as it gets, they have checked disk speeds, network speeds etc. I can’t imagine how it could be the case that 2 dedicated servers are slower than an old laptop and a cheap Azure configuration.
当我第一次回顾了2台服务器，我通过...测试了两者之间的数据库连接.
http://blogs.msdn.com/b/steverac/archive/2010/12/14/test-remote-sql-connectivity-easily.aspx
在我的笔记本电脑上(笔记本电脑到笔记本电脑，笔记本电脑变成天蓝色)DB响应不到一秒……在ISS服务器上，它花了4到5秒的时间 结束测试.我从未见过这么长时间的数据库连接，但是托管公司坚持认为这不是问题.
On my laptop (laptop to laptop & laptop to azure) the DB responded sub second...on the ISS Server it took 4-5 seconds to conclude the test. I’ve never seen a DB connection take this long, however the hosting firm insists that this isn’t a / the problem.
有人对我们接下来的工作有任何建议或意见吗?对此系统有很多关注，我不敢以如此差的性能开始全面使用.
任何评论或建议都将不胜感激.
谢谢
Adam
推荐答案
你好亚当，
服务器的配置看起来不错.因此，我的猜测是瓶颈可能是名称解析.
the configuration of the Server Looks good. So my guess is the bottleneck can be the Name Resolution.
请检查您在应用程序中使用的是短名称还是完全限定的域名.登录IIS服务器并检查名称解析.设置d2输入您的SQL Server名称，然后照看答案.你会看看那里 时间到了.
Please check if you are using shortnames within your application or fully qualified Domain names. Logon the IIS Server and check for Name Resolution start nslookup; set d2 enter your SQL Server Name and look after the answer. You will see if there is time out.
第二.从IIS到SQL Server的Tracert.它们之间是否有太多跃点?
Second. A Tracert from the IIS to the SQL Server. Are there too many hops between them?
希望这会有所帮助
亲切的问候
托马斯
这篇关于专用IIS和DB服务器上的Lightswitch性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
