Questions tagged [performance]
Questions about server hardware and software performance, or network performance.
3,202
questions
0
votes
1
answer
116
views
Store data on File Server or SQL database
We have a solution which includes storage of PDF documents.
Currently we have 50,000 documents that are 0.6 MB each (all documents same size)
We currently store these documents in varbinary(max) ...
0
votes
2
answers
2k
views
How to speed up a server using netstat & httpd.conf?
I'm using netstat commands to help optimize my httpd.conf correctly.
Here are the results:
netstat -an | grep -c :80
579
netstat -anp |grep 'tcp\|udp' | awk '{print $5}' | cut -d: -f1 | sort | uniq -...
0
votes
3
answers
159
views
Explaining the MySQL Indexing
On my journey exploring MySQL and its advanced features, especially regarding the performance optimization I bumped in some extremely important feature for SQL performance improvement mos of us knows ...
0
votes
3
answers
220
views
finding the bottleneck
I have a process running that is opening TIF files. Each TIF file is just one regular page and they are maybe 100 kB each. Every time he opens a TIF file it tries to read a barcode in a specific area ...
0
votes
2
answers
56
views
Closing the MySQL server to gain performance?
I plan on making a (servlet) application that stores its data in a MySQL server, but only reads them at startup time and write them every 4h.
I wish to let this application have as much RAM & CPU ...
0
votes
1
answer
357
views
2 JBOD enclosures 1 RAID controller vs 2 RAID enclosures
In term of scalability of performance and price, what would be better for a small business with around 20 users. I am targeting around 45TB of storage via SAS.
Here are my options:
Buy 2 JBOD ...
0
votes
2
answers
132
views
What are some of the configuration parameters that I can tweak in MySQL to improve its performance without doing any code changes?
I'm managing a MySQL server for testing purposes, and I was wondering if I can utilize the 4GB RAM available on the machine to improve MySQL's performance without doing any code changes.
0
votes
1
answer
404
views
SQL Server - VMWare install - Utilize more RAM
We have a SQL server machine - It’s a VMWare image (running on ESXi hardware etc..)
It has windows 2008 x64 standard
The SQL install is SQL 2008 standard
The virtual machine has 12gb of RAM, and 4 ...
0
votes
3
answers
2k
views
Real world stats on Web Server Performance for static content (Apache, Lighty, IIS, Cherokee, Tomcat, etc.)
On a project I'm on (private web based application accessed by 1,000s of users) we're looking to shard off the loading of static content to a separate server (e.g. as a CDN) for improved performance.
...
0
votes
2
answers
574
views
Router requests capacity
Does anybody have any idea how many requests per second a regular home router can handle?
Let's say we are talking about TCP HTTP requests. How many requests can it handle before significant delays ...
0
votes
3
answers
330
views
real-time server connections monitor
Is there any way to see in real-time the connections to my server and through which domains ?
Without having to inspect the access.log file, I would like to run a monitor in the shell instead.
...
0
votes
1
answer
1k
views
How to design high performance CIFS/SMB
Would it make sense to virtualize windows using Xen or VMware ESX and expose storage on a JBOD as NFS, instead of exposing storage as CIFS/SMB for better I/O throughput?
Is it true that the below can ...
0
votes
2
answers
233
views
big difference in HTTP response time between US and UK clients
I am looking into a problem with some images hosted in the US, that some users get really slow load times. This image for example;
http://opencirrus-g0805.hpl.hp.com/books40/UMICH/2160/10/47/23/59/...
0
votes
3
answers
121
views
how to get a web page component loading speed report from a non-technical user
We have a portal app which pulls in components from a number of different web servers. Some of our US users are reporting very slow page loading times.
I would usually use the firefox/firebug and the ...
0
votes
2
answers
162
views
Hosting for the Fastest Download Speeds
Hello I'm developing an iPhone app that downloads some reasonably chunky database files (10M-50M) my current server is hosted in the US, I am based in the UK, my download speeds aren't great, ...
0
votes
1
answer
160
views
Should I use SSD for a big multi user Access
I would really like ur opinion on this subject.
I have this case.
About 10 mde (Access Programs) with around 2GB of Access Databases
A lot of Code and a lot of data...i have tables with 2 million ...
0
votes
2
answers
252
views
Server OS usage index
Is there any server OS usage index (like tiobe index for programming languages)?
I haven't found anything better than google trends
0
votes
3
answers
2k
views
ping alternative to measure routing distance (on Windows)
in order to measure aprroximately the rouitng distance (to see if a server is close to my country or too far away) I usually use ping command.
I'm in Italy,
when I ping Italian servers I get 36ms
...
0
votes
1
answer
115
views
Will logging debugging incur a performance hit if I don't turn debugging on?
On a Cisco device, I know that enabling debugging can incur a performance hit since debugging has such a high priority on the CPU. I know that to log debugging, you have to set logging up to the ...
0
votes
3
answers
624
views
SAN performance issues storing SQL Server tempdb on a SAN that's being backed up
I'm afraid I don't know much about SAN's so please forgive my lack of detail or technical terms.
As a developer I've just completed and put on an existing production system a new application but it ...
0
votes
2
answers
207
views
Database Performance Across 3 NetApp FAS2050
I recently inherited a SQL Server 2005 box that has LUNs mounted on it from three different NetApp FAS2050 filers. The reason there are three is because the first two filers are out of space and our ...
0
votes
1
answer
363
views
Is there a way to limit the size in memory that w3wp (IIS) can get to?
Is there a way to limit the size in memory that w3wp (IIS) can get to?
I am running windows 7 x64 with IIS.
As I debug my web app, the memory taken up by IIS goes up to 4GB.
Is there a way to limit ...
0
votes
1
answer
75
views
Relative seek times for various types of storage media
Does anyone know the approximate time required to retrieve and modify a kilobyte of data for various types of storage media in a typical modern server?
Specifically:
RAM
Hard disk
SSD
This would be ...
0
votes
2
answers
529
views
Windows web server and SQL Server on same dedicated server
I'm currently trying to decide on the best approach to handle hosting a few moderate traffic websites for production e-commerce and online applications. We'd like to move to a dedicated server and are ...
0
votes
5
answers
162
views
What diagnostic information can I give my system administrator to help him diagnose the cause of slow performance on Windows XP?
I'm not a sysadmin, but a developer. Lately, my colleagues and I have all seen a big slowdown in the performance of our Windows XP machines, especially the laptops. In fact, performance is so bad on ...
0
votes
2
answers
260
views
RAID hard-drive configuration performance
Which is faster - two 500gig Western Digital hard-drives in a RAID configuration or two single Western Digital hard-drives?
0
votes
3
answers
360
views
SQL Server Monitoring [closed]
I am looking for some open source software which I can use to monitor Microsoft SQL server 2005 & 2008.
The features that I would like include:
Graphing
Recording of CPU usage
Recording of Disk ...
0
votes
1
answer
702
views
SAS Array with or without expander
Is it better to use a SAS Expander backplane for 12 drives via one SAS connection or is it better to use a SAS backplane with 3 SAS connections? This is in terms of performance, rather than expansion. ...
0
votes
2
answers
165
views
How to push out many mails efficiently using an MTA
I'm writing an email notification system that needs to send many hundreds of emails at once. The system needs to be deployed on various setups with different MTAs. Depending on the configuration, some ...
0
votes
3
answers
2k
views
Squid slow on pages with heavy javascript
We have just started using more javascript in the web interface of an internal application(php if it matters). Now that the changes are in place it is becoming very obvious that the more javascript on ...
0
votes
2
answers
203
views
Perfmon - Win 2008 - Recording Metric Twice!
I am noticing that a local perfmon I have set up to measure CPU on a Win 2008 server is actually recording two data points when recording to CPU:
"(PDH-CSV 4.0) (GMT Daylight Time)(-60)","\\SIA16\...
0
votes
2
answers
466
views
Multi-core P2V single-core performance
We have a 4-core physical server happily running along with Win2k3, IIS6, and SQL Server 2k5. Our service provider would like us to P2V the box to ESX. We are not opposed to it, but I've gotten really ...
0
votes
4
answers
214
views
Testing Java performance
There are a handful of different standard desktops and laptops at my company that I could choose from for developers on my team. Each is from a different company and comes with different load-outs of ...
0
votes
1
answer
30
views
Pin point performance issue in the past
I experienced a decrease of performance on my server and I was wondering if there is a possibility to lookback in time on a rhel8 machine. Where I can pinpoint which process claimed a lot of resources ...
0
votes
1
answer
54
views
command took very much longer to run from script than in CLI
In an AWS EC2 serverm, OS: amzn2-ami-kernel-5.10 x86_64
Trying to diagnose an issue of a slow running cron script, identified a single line of command that took more than an hour to run, everyday.
...
0
votes
1
answer
351
views
Does reverse proxying the WebSockets servers make sense from scaling perspective?
I have reverse proxy and multiple WebSocket servers behind it. I'm confused whether it makes any sense from scaling perspective, because I see it like that:
The WebSocket server A has 30,000 active ...
0
votes
1
answer
103
views
How to determine nginx/HTTPS encryption is my bottleneck?
I'm using a Digital Ocean droplet (like an EC2 host), it's Ubuntu 22.10, and running a node.js application. However, and this may be a bad idea, I'm running nginx on the same host and the application ...
0
votes
1
answer
1k
views
Nginx cache for frequent and different requests
I have a service.
This service has a GET handle(/api/v1/retrieve_blocks).
This handle's requests and responces are small, no more than 1024 characters.
regular situation:
this handle is constantly ...
0
votes
1
answer
179
views
40Gbit/s RAID10 - on a single raid adapter is it possible?
I need an ultrafast backups restore for my solution.
I am going to use two hosts: operating server and backup server.
Both servers will be connected directly via 40Gbe PCIe 4.0 8x ethernet adapters so ...
0
votes
1
answer
630
views
Disk speed on Azure Virtual Machine Scale Set is slower than advertised
I have an Azure Service Fabric cluster with 5 nodes, baked by an Azure Virtual Machine Scale Set. The size of the instances is Standard_D2ds_v4 with an advertised disk speed of max 3200 IOPS. At the ...
0
votes
1
answer
508
views
Object Storage vs HDD Block Storage
Currently I am using SSD Block Storage at Digital Ocean which is very costly. When I checked Vultr they are providing HDD Block Storage. Which is cheap.
We have to store approx 700GB of data (Mostly ...
0
votes
1
answer
1k
views
VMWare Disk Performance
I have an HP ProLiant DL380p Gen8 (VMWare 7u3 installed) with 2 pieces of 960GB SSD RAID1 arrays (total of ~1+1=2GB usage). The rest of the configuration is like
24 CPUs x Intel(R) Xeon(R) CPU E5-...
0
votes
1
answer
94
views
What could be causing twitterbot to take 6s to download small image assets?
Many (most) times twitter makes http requests for certain images, the response time (as recorded by nginx in the logs) takes 6s. Yet other sites (e.g. facebook) and sometimes twitter, typically get ...
0
votes
2
answers
682
views
Does http protocol standard support long polling?
I recently read about long-polling concept which can be used with http. I want to understand, if any http protocol standard itself supports long-polling concept, so that depending on how client ...
0
votes
2
answers
3k
views
High CPU usage by Apache/MySQL
I have a problem with CPU usage on the website that uses WordPress, Apache, and MySQL. During the day, from time to time, CPU usage by MySQL and Apache goes up to 2400% (I have 24 cores in total), the ...
0
votes
1
answer
252
views
Poor disk throughput on Google App Engine
Is there any way to manually provision IOPS for the disk used by the instances on Google App Engine?
The default throughput I get with a 256GB disk is terrible (60MiB/s burst, after which is settles ...
0
votes
1
answer
1k
views
TCP Handshake and TCP RTT when using VPN
From my server I'm measuring the TCP RTT and I was wondering what would be the difference between clients that use VPN compared to non-VPN clients.
So in the case of a non-VPN client the TCP session ...
0
votes
1
answer
2k
views
How to configure HAProxy to ignore client header `Pragma: no-cache`?
We have a web service behind a HAProxy server running in caching reverse proxy configuration. The backend servers send Cache-Control headers correctly for all responses so HAProxy can cache all ...
0
votes
1
answer
3k
views
How do I maximize nvme raid0(md) performance (in linux)?
Nvme raid0 read(and write) performance is sometimes worse than the performance of one individual underlying drive.
hdparm -t /dev/md0 :
Timing buffered disk reads: 7054 MB in 3.00 seconds = ...
0
votes
1
answer
958
views
Ubuntu Server 18.04 slow performance
I use a server with these hardware:
Cpu: AMD Ryzen 9 5950X 16 cores
Ram: 128GB DDR4 ECC
NVMe SSD HD
There I have installed Ubuntu 18.04 LTS with latest kernel. No panels only the following services ...