Questions tagged [performance]
Questions about server hardware and software performance, or network performance.
3,186
questions
7
votes
8
answers
881
views
SQL Server performance triage? [closed]
If you get a call/page about a SQL server performance issue, what do you do first?
Start a trace?
Pop up Perfmon?
Open activity monitor?
Each of these are useful tools, but what's your "sequence" of ...
1
vote
8
answers
491
views
Why my Core2Duo 2.2GHz 4GB RAM w/Vista doesn't feel faster than my single-core PM 2GHz 2GB RAM running XP? [closed]
I've recently changed laptop and I would have expect it to be quite a lot faster, but it feels more or less the same? Is it just Vista? Will it be better with Win7?
30
votes
7
answers
21k
views
What are the performance differences between Raid 0,1,5,6,10
I have heard/read different performance stories on the various raid flavors. I am curious what the agreed upon best answer is.
4
votes
6
answers
771
views
Recommended website performance monitoring services? [closed]
I'm looking for a good performance monitoring service for websites. I know about some of the available general monitoring services that check for uptime and notify you about unavailable services. But ...
1
vote
2
answers
113
views
What causes Vista to trigger startup of processes on wifi enabled?
On a Vista laptop with a on/off switch for Wifi, turning the switch on will trigger a lot of activity, killing performance and causing a lot of hard drive grinding.
The problem appears to be the auto-...
0
votes
3
answers
295
views
What utilities do you use and how do you use them when benchmarking your harddrive subsystem for a SAN replacement?
So, I have a series of questions into ServerFault about LeftHand SAN's (Questions 1441 and 4478). One of the responses I received questioned the throughput of the iSCSI data returning from the SAN ...
8
votes
6
answers
36k
views
What is the maximum memory that an IIS6 web site/app pool can use?
I have an IIS 6 server running on Windows 2003 SP2 x86. The server has 4GB of RAM and runs consistently with 2GB allocated.
I realise that with x86, the server won't utilize all of the 4GB RAM and ...
5
votes
6
answers
1k
views
How to do periodic Sql Server performance monitoring and troubleshooting?
What are the best tools and processes for periodically monitoring and troubleshooting sql server performance issues?
3
votes
3
answers
6k
views
How does the LeftHand SAN perform in a Production environment?
I previously asked this ServerFault question: Does anyone have experience with lefthands VSA SAN
The general consensus looks like it does not perform well enough for a production SQL server even at ...
5
votes
7
answers
56k
views
Windows networking performance (SMB/CIFS)
Are there registry settings or other settings available to tune Windows networking (SMB/CIFS) performance?
I'm trying to get maximum throughput for large file copy operations but any settings would ...
6
votes
7
answers
14k
views
How to optimize performance for MSSQL databases?
I'm a dba with a database with ~280 tables, and total datasize of ~1,5GB. I'd like to tune the database to make it perform better.
What do you do to keep your SQL databases performant? How much ...
11
votes
3
answers
19k
views
Xen vs. VirtualBox under heavy load?
Which performs better under heavy CPU and memory usage on the virtual servers, Xen or VirtualBox?
10
votes
8
answers
7k
views
Best file system for external (USB) hard drives/USB memory media
Almost all external USB hard drive and USB memory media/sticks come today preformatted with FAT32.
As far as I know the only advantage of the file system is the compatibility among OSes and devices.
...
5
votes
6
answers
12k
views
For a small home network, is there any point to running Squid? [closed]
For a small home network -- two laptops, two desktops, plus the main server -- should I expect much gain by running Squid on the main server? I fully understand the value of running a caching name ...
3
votes
3
answers
9k
views
Fastest option for a PHP webserver
I need to serve a PHP app that handles lots of requests. I want to know if there's any real benefit in going with anything other than Apache, and what are the pros and cons of the alternatives.
I ...
17
votes
9
answers
18k
views
How do I profile MySQL?
What tools exist to profile MySQL, like how MSSQL 2000+ does with the SQL Profiler?
I'd want to trace things like SQL statements executed, execution times, execution plan, etc.
2
votes
3
answers
2k
views
Virtualization: RAID the Host OS or VM Storage?
If I only had 1 pair of 15,000 RPM SAS drives in RAID 0 to dedicate to a VM box, would it be best to
a) put the HOST OS on the raid drives and put the VM's on a single SATA 10,000 RPM drive
b) put ...
39
votes
5
answers
81k
views
How to identify I/O bottlenecks on a Linux server?
How do you determine that the performance of your Linux server is I/O bound and, perhaps more importantly, what process or processes are casuing the problem?
2
votes
4
answers
599
views
Whats the current most effective folding farm hardware setup?
I'm interested in getting a folding farm setup but I guess this question can apply equally well to any computation-intensive cluster. Basically the goal is to:
Maximize performance in terms of (...
1
vote
2
answers
441
views
Improving RDP Login Performance
We have a Windows 2008 Server located in a remote data center connected over a highly latent (~200ms) 3MBps VPN connection to our primary location. This server has the Domain Controller and Terminal ...
0
votes
3
answers
555
views
Why is SQL Server slow on IBM Shark hardware
I have a performance problem with a SQL Server data warehouse solution on a blade connected to an IBM Shark. Disk I/O performance seems to be pathologically slow with excessive page latch wait times. ...
2
votes
5
answers
591
views
How to best tune a Linux development machine?
How to best tune a Linux PC for development purposes?
12
votes
4
answers
524
views
How to best tune a Windows development machine?
How to best tune a Windows PC for development purposes?
2
votes
4
answers
4k
views
How to best optimize an Oracle database for writes?
How can I maximize the write performance without impacting reads?
4
votes
2
answers
4k
views
How do I debug an IIS problem where the requests queued suddenly ramps up and the server can't respond?
I have an IIS 6 server serving an application using a mix of classic ASP and ASP.NET.
I'm increasingly getting problems where the number of requests in the ASP.NET requests queue (observed using the ...
4
votes
4
answers
2k
views
Severe write performance problem
[Sorry, I tried to stay short but it just was not possible]
I'm running Linux 2.6.22.19 with linux-vserver 2.3.0.34 on a Fujitsu Siemens Primergy RX200 S3 for development purpose. Intel(R) Xeon(R) ...
3
votes
7
answers
66k
views
What can cause Apache HTTPD to use 100% CPU indefinitely
An application running a lightly loaded Apache HTTPD 2.0 has occasionally had problems where one (or more?) of the Apache processes took 100% CPU. We currently run HTTPD 2.2, I we may have seen this ...
2
votes
2
answers
2k
views
What are good tools/techniques for monitoring and debugging IIS performance problems?
I'm looking for the best tools/techniques for monitoring IIS performance problems and then debugging them. I'm particularly interested in ASP.NET applications.
This may be a combination of tools or ...
1
vote
4
answers
816
views
Citrix login performance
How do you go about troubleshooting application startup time in a Citrix environment? We have some users that get very fast startup time, others take forever when starting the same application on ...
13
votes
11
answers
14k
views
Should I run my database off of a RAID 5 configuration?
I've heard that the write performance of RAID 5 can be appalling at times. While I want the redundancy that it provides I don't want to sacrifice my database insert/update times.
Is this something I ...
3
votes
3
answers
326
views
Building optimal custom machine for Sql Server [closed]
Getting the hardware in the mail any day.
Hardware related to my question:
x10 15.5k RPM SAS Segate Cheetah's
x2 Adaptec 5405 PCIe Raid cards
Motherboard has integrated SAS raid.
Was thinking I ...
7
votes
1
answer
1k
views
ext3 file system performance tuning: what metrics to monitor
I have a high-IO application that is working, and scaling well to date. Over the past few months we've been trying to look down the road and predict where our next bottlenecks will occur. One of ...
15
votes
4
answers
1k
views
HTTP Compression on IIS 6.0 (Windows Server 2003)
There are many things you have to do/consider when you want to enable HTTP compression on IIS 6.0 (Windows Server 2003).
Can somebody please provide a comprehensive list of the actions you have to ...
14
votes
6
answers
550
views
First days online : how not to kill your site
Suppose you have this fancy new site, with lots of data (like big images), and you're about to put it online. If you do "too much" publicity, during the first days, the site will be overwhelmed with ...
8
votes
4
answers
2k
views
IIS Optimization
What kind of optimization (performance or whatever) do you use when going live with IIS (on windows 2003) ?
Currently, I use 1 application pool per web site, but I think I can do more :)
0
votes
2
answers
7k
views
Are independent persistent disks faster than dependent ones in vmware server 1?
Please can you help me compare disk types for vmware server?
I know "independent nonpersistent" is slower. But what about "independent persistent" versus "dependent" (or how do you call this one?)
...