All Questions
Tagged with performance sql-server
129
questions
0
votes
2
answers
65
views
Server's Disk Queue Length is high, but Disk Bytes/sec is lower than it's capable of
I have an environment running SQL Server on a Windows VMWare platform using a SAN with SSDs set up in RAID 6, and using Veeam for server backups and LiteSpeed for SQL Server backups.
I've had a ...
- 101
2
votes
1
answer
1k
views
How to debug the cause of my suddenly extremely slow running database backups maintenance plan?
(Originally posted on DBA.StackExchange.com but closed, hopefully more relevant here.)
Alexander and the Terrible, Horrible, No Good, Very Bad...backups.
The Setup:
I have an on-premise SQL Server ...
- 121
1
vote
1
answer
585
views
Best Practices for Deploying Microsoft SQL Server on AWS on EC2 instance with SSD storage
Does it makes sense to install SQL Server 2017 on one single SSD drive on m5.xlarge with tempdbs, databases, program files, backups and logs for best performance?
According to Amazon EBS specs the ...
- 11
0
votes
1
answer
4k
views
sql server slow only on LAN
I have a MS SQL Server instance on my server.
Running select * from sys.columns takes 00:00 seconds. (just as a sample, most queries have same issue)
When i run the same query in SSMS, it takes 30 ...
1
vote
1
answer
1k
views
SQL on Azure VM Disk Striping and Location of Data/Log Files
Per the Performance best practices for SQL Server in Azure Virtual Machines documentation:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance
...
- 143
0
votes
0
answers
45
views
Switching application from SQL Auth to Windows Auth causes connection queing under stress
We're switching from using SQL auth to windows auth per microsoft best practices (https://support.microsoft.com/en-ca/help/2028697/recommendations-and-guidelines-on-configuring-the-authentication-mode)...
- 619
2
votes
1
answer
4k
views
Are the limitations of SQL Server Express the bottleneck?
Question: What is the best way to determine whether the limitations of SQL Server Express are the bottleneck in an environment? Are there some performance counters that would be a good indication for ...
- 1,852
3
votes
2
answers
286
views
Is there a performance overhead in having 2 instances of SQL Server 2014 running on the same VM
I have inherited an SQL Server 2014 which has been setup with 2 instances of SQL Server. Each instance hosts a number of databases and each instance has been setup to use all the CPU (4 processors) ...
- 143
0
votes
0
answers
78
views
Analyze performance issues, client, server, and database without source code?
I work in a support and have now found performance problems from a customer. There is a Windows client application where the customer works in that communicate with a Windows Server and a MS SQL ...
- 95
-1
votes
1
answer
293
views
SQL server suddently started to write huge amount of uknown data to tempdb [closed]
so today our sql server suddently started to write a huge amount of data to the tempDB that resulting in disk spike so it can take up to 5 min before we can do anything in our program
tryed to take ...
4
votes
2
answers
1k
views
Diagnosing slow data processing on a VM
We're trying to diagnose a VM apparently running slowly, from inside the VM.
The situation:
We have an IIS-hosted application on Windows Server 2008R2 running on a 6-core, 12GB virtual machine.
We ...
- 161
1
vote
0
answers
2k
views
What is the optimal strip size/full stripe size on a RAID 10 array for a database server?
I'm setting up a new SqlServer database server at work. The machine is a HP Proliant DL368 Gen9 with the SSD disks. When trying to create the array, I have to select the stripe/full stripe size. This ...
- 111
1
vote
2
answers
783
views
Intermittent Server Performance Degradation Troubleshooting
I have been troubleshooting an intermittent server performance issue for too long and I am running out of ideas. I am looking for any suggestions as to how I might be able to identify the cause of ...
- 111
3
votes
1
answer
358
views
Finding SQL Server Bottleneck - not CPU, IO, available memory
I'm trying to identify the bottleneck on a new SQL Server implementation (2012 Enterprise). I've been running some meaty queries/ETL jobs which are taking a considerable time - but I'm having ...
- 31
0
votes
2
answers
73
views
SQL Server performance
I created a simple website (using C#) that import 70k rows data from a text file to my database but I got this problem:
It takes 3 minutes to import 70k rows data to database on my desktop (DELL ...
- 1
0
votes
0
answers
70
views
Conservative Azure Windows VM to Run SQL Server 2008 R2 [duplicate]
For testing purposes I need to set up three Azure Windows VMs to each run an instance of SQL Server 2008 R2 each holding one DB of approx 100GB. There will be quite a few complex stored procedures/...
- 101
1
vote
1
answer
1k
views
Server high memory and cpu - no leads
I've been asked to troubleshoot a server hosting our application at a client's facility.
The client has complained to us on two separate occasions in the last week - week and a half. In one instance ...
- 111
2
votes
1
answer
1k
views
Azure IO performance sql server [duplicate]
We are in the process of migrating our on-premises sql server to Azure and I am having trouble with the IO performance.
I have created a new D14 instance and attached 16 virtual disks at 100GB in ...
- 301
0
votes
1
answer
1k
views
Sql Server 2012 Disk I/O Too high
I am running SQL Server 2012 on windows azure VM Windows server 2012.
This is a live Database, about 250GB, with high usage.
I applied some best practice articles for the temp-db long ago, and also ...
- 191
0
votes
1
answer
181
views
Perfmon % Processor Time unbalanced
I am somewhat of an accidental DBA, and I'm troubleshooting a SQL Server box where performance has been notoriously poor (as reported by the customer). I was not involved in the initial planning of ...
- 111
1
vote
1
answer
870
views
Intermittent performance issues on Azure Web Application with ASYNC_NETWORK_IO errors
Our web application is suddenly experiencing intermittently slow performance (slow page loads, slow ajax calls going from <1 sec to over 20 secs). The only clue is when the application slows, we ...
- 11
0
votes
2
answers
65
views
Recommended Setup
I have been running into issue with my MSSQL Database setup with speed. Here is my scenario.
About 100M Rows
Average: 1k Updates Per Second
Hard Drives: RAID 10 SSD MDF
--Active Time: 0
Log Drives:...
1
vote
2
answers
1k
views
Benefit of extra memory in server hardware beyond what SQL Server can use?
My previous related question was flagged as "Not Constructive", because I asked to compare SQL Server & Oracle. So this time I will ask only about SQL-Server.
My company has built an ...
- 13
1
vote
4
answers
3k
views
TCPing reports 20ms latency between Web Farm and DB
We have a IIS web farm sitting in a DMZ connecting to a MSSQL DB(Windows Cluster). After troubleshooting some performance problems we stumbled upon strange network behavior.
We wanted to test network ...
- 111
2
votes
1
answer
1k
views
MSSQL 2012 usage of the CPU cores?
I am on decision border which processors I shall go for, and I need an information on "how actually works MSSQL 2012 with the CPU cores ?"
basically my question is follow :
1 query which extracting ...
- 161
0
votes
3
answers
501
views
MAXDOP and Interesting Performance Experiences
i would like to receive an advice on the following topic.
With one of our products from our company we "connect" to an existing database on customers side and import orders into our own SQL Server to ...
- 3
-2
votes
4
answers
2k
views
will a 100GB database with large tables on MSSQL 2008 server run on a 3GB RAM system? [duplicate]
This will be only for testing and developing.
I have a 100 GB DB I am working on and need a sanbox envorinment.
The only hardware I have is a desktop with 3GB and 32bit.
I am able to install SQL 2008 ...
1
vote
1
answer
1k
views
MongoDB Master and Slave - Windows or Linux [closed]
I have recently moved my MS Sql Server DB to MongoDB (2.0) on Windows Server 2008. Its containing 2 databases with following stats. (both databases get around 100 reads/writes per second). These ...
- 155
0
votes
2
answers
2k
views
SQL server performance when using integrated security for authentication?
I was wondering about the performance impact of using Windows Authentication to connect to a SQL server in a Winforms application versus using SQL Authentication. In our current model, everyone uses ...
- 103
1
vote
0
answers
61
views
My server is slower than the average user's computer, should I still offload Access queries to SQL Server? [duplicate]
Possible Duplicate:
How do you do Load Testing and Capacity Planning for Databases
I have a database set up with MS Access 2007 front ends and an SQL Server 2005 back end. At the moment, all the ...
- 151
1
vote
1
answer
1k
views
Is there a negative impact to using SQL Server with a lower compatibility level
We have SQL Server 2008 R2 which we are using for a database with a compatibility level set as 2005 (90).
We will by upgrading it to 2008 at some point, but in the meantime I would like to know if ...
- 143
1
vote
2
answers
385
views
Servers configuration to improve performance and offer redundancy for ASP.NET site with SQL Server
I'm administrating a fairly large website (currently about 300 thousand page views a day) which is expected to grow fast. Currently both IIS and SQL Server are running in a quad core server, with RAID ...
- 171
-1
votes
1
answer
171
views
Page Fault of 1,000,000 in 64 GB RAM Server [closed]
I have a 64 bit Machine that runs SQL Server. It has 64 GB RAM.
It is giving around 1,000,000 Page Faults per second. Is it OK or it is giving too many Page Faults? if the number is hign the what ...
- 9
1
vote
2
answers
4k
views
Ridiculously slow queries on Microsoft SQL Server 2008 R2
I'm getting really slow queries in MS SQL Server 2008 R2 on my dev machine. This problem has been plaguing me for about a month. Other developers don't have the same problem, but we all run the same ...
- 259
2
votes
0
answers
186
views
Full Text Search query elapsed time varying wildly
Database Version:
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 (...
- 73
0
votes
4
answers
2k
views
What HD/SSD performance benchmarks are relevant to SQL Server?
I'm looking to buy an SSD for a SQL Server computer, what benchmarks should I be comparing? High/low queue depth? Random/sequential transfer rates? IOPS?
- 173
1
vote
2
answers
225
views
How do you control which portion of SQL Database gets loaded into Server Memory?
My SQL Server Machine has 6GB of RAM but the database size is 20GB. The Database is mainly an events log, clustered-indexed by time.
The clients are mostly interested in the latest data. They want ...
- 1,345
0
votes
1
answer
102
views
Performance analytics via DBMS "plugins", or other solution
I'm working on a systems monitoring product that currently focuses on performance at the system level. We're expanding out to monitoring database systems. Right now we can fetch simple performance ...
- 259
0
votes
4
answers
3k
views
SQL Server: One 12-drive RAID-10 array or 2 arrays of 8-drives and 4-drives
Setting up a box for SQL Server 2008, which would give the best performance (heavy OLTP)? The more drives in a RAID-10 array the better performance, but will losing 4 drives to dedicate them to the ...
- 197
2
votes
3
answers
8k
views
How can I make my SSIS process consume more resources and run faster?
I have a daily ETL process in SSIS that builds my warehouse so we can provide day-over-day reports.
I have two servers - one for SSIS and the other for the SQL Server Database. The SSIS server (...
- 327
1
vote
2
answers
337
views
How to I properly measure the network performance of SQL Server across a WAN?
We're in the process of migrating a number of servers to a different data center. As a stop gap measure, we've moved a set of web servers to the new data center and have left their supporting SQL ...
- 111
2
votes
1
answer
440
views
Suggested or Best practices for network architecture for ASP.net web application
Currently I have one server that runs an ASP.net web application (on IIS) and this is also running a SQL Server database.
I am getting more and more traffic and soon I will need to increase the ...
- 275
2
votes
1
answer
1k
views
Windows Performance Monitor keeps trying to add unwanted counters
I have been running a Data Collector Set for SQL Server for a week, and everything was going just fine until I tried clicking on Action -> Save Current View and now it always tries to add the ...
- 180
1
vote
1
answer
646
views
SQL Server query result transfer time over VPN (WAN)
I have a mysterious phenomenon on a remote SQL Server 2005 which I manage and query using SQL Server Management Studio. I connect to the server through a VPN tunnel (provided by an ISP, about 8 MBit/s ...
- 28.5k
0
votes
1
answer
1k
views
When to / not to you index and table compression in mssql server
*I am asking this on SO not SF because I am a developer and am interested in the data access performance aspects of this not the Administration aspect.
I've been trying to do some research / learning ...
- 443
0
votes
1
answer
104
views
Server Configuration
Recently we have got problems with performance in SQL Server 2008 Enterprise.
One idea to solve it is to scale up, i.e. improve hardware of the server.
SQL Server 2008 has 2 instances that are ...
- 145
1
vote
4
answers
4k
views
High CXPACKET wait type in SQL Server even with MAXDOP = 1
I have always had a very high CXPACKET wait type, and I've been told that it stems from parallel processing, and I should keep MAXIMUM DEGREE OF PARALLELISM = (Nº Processors / 4), or 1 in my case.
...
- 113
1
vote
2
answers
226
views
Is there a performance hit when using an external URL rather than an internal IP to address a server in SSIS?
I'm running SQL Server Integration Services (SSIS) packages in SQL Server agent every day. I've been monitoring the performance of the packages and see a lot of network activity in Resource Monitor. I'...
- 243
0
votes
2
answers
175
views
Diagnosing intranet performance issues
I'm attempting to figure out why our intranet is having performance issues. From some basic troubleshooting, I'm leaning towards the issue being our SQL server, which is hosted on a separate server. ...
- 101
7
votes
1
answer
637
views
sys.dm_exec_query_stats interaction with recompilation
We use sys.dm_exec_query_stats to track down slow queries and queries that are IO offenders.
This works great, we get a lot of very insightful stats. It is clear this is not as accurate as running a ...
- 1,979