l********n
发帖数: 6 | 1 SQL Server 和文件系统都在同一个服务器上. 请问高手以下几个问题:
1. 庞大的文件系统是否会引起SQL Server 问题, 比如shut down SQL Server or
slow down server 运行.
2. 如果要把两个系统分开, 保留SQL Server, 把文件系统移到另一个服务器上,这是
不是最好的选择?
3. 当多个程序在运行访问SQL Server时, 有时SQL Server 会产生system lock, 导致
程序运行非常慢, connection timeout 时有发生, 应该如何避免.
谢谢指教! | j*****n
发帖数: 1781 | 2 I guess you are talking about one independent server provides both database
and file services.
if so,
1. sure it is very bad behavior for your server, it does slow down your SQL
Server performance much due to heavy I/O bottle neck -- large amount of
file movement: reads/writs toward your physic disk(s).
2. absolutely yes. please also be sure that each server is connected to
different SAN/Array.
3. that might because of too many requests are trying to establish
connection to your SQL Server, but | l********n
发帖数: 6 | 3 Thank you for your input.
Question:
1. How to make sure that each server is connected to
different SAN/Array.
2.---- You can try to increase the number of connection
limit to higher numbers depend on your Server capacity.
Do you mean default 5 of Minimum query plan threshold for
considering queries for parallel execution estimate of
SQL Server property? If yes, what's minimum you suggest?
What different by increase it?
Thanks | j*****n
发帖数: 1781 | 4 1. discuss it with your server/storage support team.
2. no, go Enterprise Manager, right click the server name, choose Properties
, you will see it in Connections tab.
【在 l********n 的大作中提到】
: Thank you for your input.
: Question:
: 1. How to make sure that each server is connected to
: different SAN/Array.
: 2.---- You can try to increase the number of connection
: limit to higher numbers depend on your Server capacity.
: Do you mean default 5 of Minimum query plan threshold for
: considering queries for parallel execution estimate of
: SQL Server property? If yes, what's minimum you suggest?
: What different by increase it?
| l********n
发帖数: 6 | 5 2: current setting is 0 = unlimit
timeout = 600
What else do you think I need to check to prevent system lock and connection
timeout occur?
Thank you | j*****n
发帖数: 1781 | 6 then I need ask you some questions:
1. server memory, how many memory assigned to sql server.
2. version of sql server including patch number
3. # of network card and speed for each card
4. storage plan: system drive, Data drive, log drive, temp db drive, quorum
drive
5. spc of cpu(s), # of cpus assigned to sql server
6. # of apps connecting to sql server,
7. authentication model for each app
my suggestion is that you'd better run Profiler and Perfmon to find out
where is the bottle neck.
btw, | l********n
发帖数: 6 | 7 I don't know most of question except 2.
version is 8.00.760(SP33)
I'll find out soon.
What's your email?
Thanks |
|
