0
votes
0answers
42 views

SQL Server 2014 Standard 2014 no access and bad preformance

My company looks after a server which is running SQL Server 2014 Standard Edition. The main application database on the server is replicated out to about 20 subscribers. The server has only been in ...
0
votes
1answer
26 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 ...
1
vote
1answer
84 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 ...
0
votes
0answers
45 views

What is a good set of performance counters to measure scalability bottlenecks

We're moving our enterprise product to the cloud (IAAS) and are determining how many users we can support on a single VM. Our product uses SQL Server, SharePoint and a bunch of WCF services. What ...
0
votes
2answers
56 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 ...
1
vote
2answers
145 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 ...
1
vote
4answers
478 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 ...
2
votes
1answer
602 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 ...
0
votes
1answer
162 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 ...
-2
votes
4answers
363 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 ...
0
votes
1answer
223 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 ...
0
votes
2answers
317 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 ...
1
vote
0answers
48 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, ...
1
vote
1answer
257 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 ...
1
vote
2answers
174 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 ...
-1
votes
1answer
133 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 ...
1
vote
2answers
925 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 ...
2
votes
0answers
130 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 ...
0
votes
3answers
727 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?
-4
votes
2answers
241 views

Local SQL Server much slower than remote

I have an application using an SQL Server DB for it's data. Simply put, I can run the code pointing to a local SQL Server(2008). Performance SUCKS BALLS. One particular move function takes about 22 ...
1
vote
2answers
214 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 ...
0
votes
1answer
67 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 ...
0
votes
4answers
702 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 ...
2
votes
3answers
3k 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 ...
1
vote
2answers
255 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 ...
2
votes
1answer
331 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 ...
2
votes
1answer
429 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 ...
1
vote
1answer
320 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 ...
0
votes
1answer
239 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 ...
0
votes
1answer
95 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 ...
1
vote
4answers
1k 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. ...
7
votes
1answer
336 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 ...
2
votes
1answer
164 views

SQL Server 2008 Partitioned Table and Parallelism

My company is moving to SQL Server 2008 R2. We have a table with tons of archive data. Majority of the queries that uses this table employs DateTime value in the where statement. For example: ...
1
vote
2answers
366 views

How do large blobs affect SQL delete performance, and how can I mitigate the impact?

I'm currently experiencing a strange issue that my understanding of SQL Server doesn't quite mesh with. We use SQL as our file storage for our internal storage service, and our database has about half ...
4
votes
1answer
866 views

High disk time on SQL Server

We have a dedicated SQL Server 2008 R2 Enterprise Edition. The setup is: D: (data files) - stored on local ssd disks (not the same disks as log files) (raid 10) E: (log files) - stored on local ssd ...
0
votes
0answers
124 views

Where to start fixing an IO Bottle neck in SQL Server?

I recently came across an interesting article that went over using IO statistics to identify the causes of performance issues. After examining my statistics i came to the determination that i had a ...
2
votes
3answers
187 views

Where to start fixing an IO Bottle neck in SQL Server?

I recently came across an interesting article that went over using IO statistics to identify the causes of performance issues. After examining my statistics i came to the determination that i had a ...
1
vote
1answer
542 views

SQL Server - VMWare Install - Transactional Replication causing 100% CPU

I am having severe trouble with a SQL Server - in particular, with transactional replication. We used to have a Windows 2003 physical machine, with SQL 2000. We call this “WebDB” The server was ...
0
votes
1answer
368 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 ...
2
votes
6answers
251 views

SQL Server 2005: Selects good, Inserts bad

We've come across a perplexing problem with our database application. We're running the application in 3 different (but similarly spec'd) environments. Select Insert Env1 0.81ms 0.94ms ...
1
vote
2answers
299 views

SQL Server Full Text Search resource consumption

When SQL Server builds a fulltext index computer resources are consumed (IO/Memory/CPU) Similarly when you perform full text searches, resources are consumed. How can I get a gauge over a 24 hour ...
2
votes
1answer
1k views

Hyperthreading vs. SQL Server & PostgreSQL

I have read that hyperthreading is a "performance killer" when it comes to DBs. However, what I read didn't state which CPUs. Further, it mostly indicated that I/O was "cut to < 10% performance". ...
1
vote
1answer
103 views

Are there any performance difference between Microsoft SQL server 2008 Editions

I always wonders this. For example you are using Microsoft SQL server 2008 web edition. It supports your hardware fully. And you upgraded it to Datacenter edition. would there be any performance ...
3
votes
6answers
507 views

For a new database server, which partition will benefit the most from SSDs?

I'm speccing a new database server for a Microsoft SQL Server environment. In the past, I would create four separate RAID arrays for OS, data, transaction logs, and tempdb. Now, I am looking at the ...
1
vote
2answers
1k views

Computer specs for a large database

What sort of computer specs (CPU, RAM, disk speed) should I use for running queries on a database of 200+ million records? The queries are for a research project, so there is only one "user" and only ...
0
votes
4answers
157 views

SQL Server: Shared disk cabinet performance

Our server admin has hatched a plan to move all storage to a central disk cabinet, and have every server use that. We have a central SQL Server that is heavily use (200+ concurrent users) and I am ...
0
votes
2answers
133 views

What is the best high-performance solution for server side

We are building the server side of some gaming platform where a great load of mobile devices (thousands, if not tens of thousands) connect to a server, send some small information each second (let's ...
0
votes
4answers
2k views

Performance Monitor w/ SQL Server - how many counters is too many?

I'm doing some performance analysis using the built-in Windows Performance Monitor, both on general hardware and SQL Server. I've been reading a lot about which performance counters to use; in ...
1
vote
2answers
291 views

Overloading a Windows SQL server

We've been looking at a SQL based legacy system for the past few months trying to improve performance and have done as much as possible with the code base so now we're turning our attention to the ...
5
votes
3answers
1k views

Certain SQL queries performing very poorly in ESXI hosted environment

We recently set up a new machine with 8 dual-core CPUs, 20 GB RAM, and 3 1-TB drives set up in a RAID of some sort resulting in 2 1-TB drives we actually get to use (I'm not the hardware guy here). ...