Questions tagged [windows-server]
All versions of Windows Server. Please also add a version-specific tag like windows-server-2012 if that is relevant to the question.
436
questions
35
votes
4
answers
18k
views
Slower SQL Server performance after allocating more CPU and RAM
We have SQL Server 2008 R2 (10.50.1600) running on a virtual Windows 2008 R2 server. After upgrading the CPU from 1 core to 4 and the RAM from 4 gb to 10 gb, we've noticed the performance is worse.
...
- 505
19
votes
2
answers
155k
views
The value could not be converted because of a potential loss of data [closed]
Let me start out by clarifying that this is not a duplicate question, nor a potential duplicate for that matter. I have tried implementing every answer to every single variant that already exists of ...
13
votes
2
answers
9k
views
SQL Agent - PowerShell step "syntax error"
I have the following code setup in SQL Agent Job step that is not running. The message received is simply:
Unable to start execution of step 1 (reason: line(46): Syntax error). The step failed.
...
user507
13
votes
3
answers
4k
views
I'm using the SQL Server Agent to schedule even non-database tasks - is this a bad idea?
Since I'm a DBA (and in many cases, the de-facto sysadmin), SQL Server is installed on pretty much every server I have to work with regularly. I realized recently that I've been using the SQL Agent as ...
- 1,228
13
votes
4
answers
59k
views
I need the reason why we should not install SQL server on the domain controller
I am a system administrator for a small firm. Now we consider to rollout Windows Server 2008 R2 for the firm. We plan to implement Active Directory. We would also like to upgrade RDMS, from SQL server ...
- 131
12
votes
3
answers
55k
views
Moving SQL Server to different domain
What are best practices/important steps when the Windows Server machine hosting SQL Server 2008 R2 is moved to another domain? What steps definitely/might need to be done for SQL Server before and ...
- 473
10
votes
4
answers
6k
views
Increased memory to server, but do I need to change page-file size?
I'm running SQL Server 2017 on Windows Server 2012 R2 and have increased the memory from 256 GB to 512 GB.
I've noticed the following configuration for Virtual Memory:
C: [OS] = 2 GB
G: [DATA] = ...
- 131
10
votes
2
answers
15k
views
SQL Server Cumulative Updates - not visible in Windows Update
I just installed all possible Windows updates on WS2008R2/SQL2012 instance. When I run
SELECT @@VERSION
I get
Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
May 14 2014 18:34:29
Copyright ...
- 1,405
10
votes
2
answers
25k
views
Changing Data Directory on MySQL DB Server
I have installed mysql server 5.6.24 on Windows Server 2012 R2.
I imported dump files and the data files are stored in C:\ProgramData\MySQL\MySQL Server 5.6\data
I want to change directory like D:\...
- 101
9
votes
1
answer
10k
views
SQL Server Service does not start automatically after system restart
I have a SQL Server system that reboots weekly (after installing Windows Updates).
The last three weeks I have seen that the SQL Server service does not start when the server comes back up (...
- 1,888
8
votes
3
answers
26k
views
Data warehouse server. How do you calculate RAM/CPU specifications?
I am trying to write a spec for a data warehouse server for our planned data warehouse upgrade.
As we run virtual servers on VMWare hosts we have the ability to add or remove resources as necessary. ...
- 3,175
8
votes
1
answer
22k
views
'The computer must be trusted for delegation and the current user account must...' error when trying to connect to sql server 2008
Our admin set up a brand new Windows 2012 R2 server with Visual Studio 2015. When I try to connect to an existing sql server 2008 database (running on a windows 2008 r2 server) from Visual Studio, ...
- 427
8
votes
1
answer
28k
views
Configuring SQL Server 2016 to allow remote connections
I have SQL Server 2016 installed on Windows Server 2016 Core. Locally, it seems to be working. I can connect using SQLCMD.exe and do some basic selects and what not.
From remote, I cannot connect. ...
- 335
8
votes
1
answer
5k
views
Should I disable HyperThreading
BACKGROUND I've recently been looking into some fairly high CXPacket wait times recently which has had me using SQL Sentry to monitor processor activity pretty closely.
One thing that I've noticed as ...
- 3,511
7
votes
2
answers
367
views
SQL Server 2012 - SA account probe
On one of my servers (Win 2012 R2), SQL Server 2012 is constantly under attack with the SA account being hit like 10 times per second with different passwords. I don't have an SA account but still I ...
- 173
7
votes
2
answers
7k
views
Run Powershell Script From Agent As Administrator
I need to recycle an AppPool in IIS on my server when the SQL Server Service starts.
The route I am taking is to have a startup stored procedure which runs an Agent job that has a Powershell job ...
- 1,888
7
votes
1
answer
2k
views
How does SQL Server calculate the initial size of a (compressed) backup?
When a backup is created, SQL Server guesses(?) the a size of the intial backup file. Later on, maybe when it appends the log the size will be re-adjusted, sometimes multiple times until the final ...
- 1,353
7
votes
3
answers
10k
views
SQL Server service shutdown due to 'bad?' SSL cert
This morning it transpired that SQL Server 2012 service running on Win2012 had shut itself down. When I logged in as the server admin and tried to access SSMS, after entering my credentials I got the ...
- 830
7
votes
2
answers
5k
views
Is it safe to run a Windows Failover Cluster Public and Heartbeat on a Single NIC?
I have a 2-Node Windows Failover Cluster (Windows Server 2016, SQL Server 2017) with a Quorum Disk Witness on fibre-connected shared storage.
How important is it that the heartbeat is on its own ...
- 536
7
votes
1
answer
34k
views
Fastest way to move MongoDB to a new server
I have to move a 200GB MongoDB from one server to another (both Windows 2016 OS). During this operation, it is assumed that the accompanying program will be offline, so no need to worry about ...
- 111
7
votes
1
answer
269
views
Failover timeout problem
I'm looking for an additional bit of help with regard to some problems I'm looking at for one of my company's clients. Basically I have two related problems with regard to a 2-node active/active ...
- 347
6
votes
2
answers
2k
views
Why is the processor % different in Activity Monitor vs Resource Monitor?
I'm tracking a significant difference between the processor % reported in the Activity Monitor for SQL Server vs the total processor % used in the Resource Monitor. I'm seeing about a 50% difference ...
- 1,761
6
votes
3
answers
26k
views
How to allow connections to SQL Server with 2 differents ip
I have a small issue here: I have a SQL Server instance 2012 (let's call it SQLINSTANCE) on a cluster. I also have 2 network interfaces for this instance:
- SQLINSTANCE.my.network
- SQLINSTANCE.mgt....
- 143
6
votes
2
answers
1k
views
Intermittent SQL Delegated Authentication Errors
Here is an odd issue that is causing me to lose all my hair.
Every few days or so our delegated authentication from one SQL server to another fails with the error:
Login failed for user 'NT AUTHORITY\...
- 61
6
votes
2
answers
26k
views
SQL Server Windows NT 64 bit Sudden High CPU Spike
I am facing a strange behavior of my SQL Server 2016 web edition. SQL Server Windows NT 64 bit suddenly jump to use 90% of the CPU and then it goes down after 5 sec, then the spike comes again after 3 ...
- 163
6
votes
1
answer
7k
views
SQL Server and SSPI handshake failed error
Recently I faced an issue where users from one domain were unable to login to SQL Server and getting this error:
Error: 17806, Severity: 20, State: 2.
SSPI handshake failed with error code ...
- 1,898
6
votes
2
answers
27k
views
SQL Server Service Account login or password is not valid error
I am trying to install SQL Server 2012 Express on a Windows 2012 Server for test purposes. This machine is part of our company domain.
During installation I am trying to use one of domain account ...
- 458
6
votes
1
answer
13k
views
Multiple IPs registered for listener when using AlwaysOn AGs w/ multi-subnet clustering
We are testing AlwaysOn Availability Groups on a WSFC multi-subnet cluster and using dynamic DNS registration. Our issue is that sometimes the IP for the Availability Group Listener (AGL) in the ...
- 61
5
votes
2
answers
6k
views
when applying a sql server cumulative update or service pack on a virtual machine - what could be a safe way of stopping VMWaretools?
While applying cumulative updates to sql server 2016 SP1, there are a bunch of services and applications that need to be stopped for the update to go on.
Among those is the very core of the virtual ...
- 15.7k
5
votes
3
answers
9k
views
How can I wipe all databases and users from a SQL Server database?
Okay, here is the story.
I have a Windows 7 Ultimate box with a SQL Server 2008 R2 Standard installation that I inherited from a person who left the company long before I started at my company. No ...
5
votes
1
answer
6k
views
Always On AG is Down when service is stopped
I have SQL Server 2014 running on Windows Server 2012 R2.
There are three nodes, one is remote DataCenter. So two nodes have voting.
Failover Cluster is using file share witness on remote server.
If ...
- 243
5
votes
1
answer
15k
views
How many users are supported on SQL Server 2012 Express?
I would like to say that i have gone through some of the sql blog and MSDN BOL, but still there is some confusion in mind like.
The limitation of SQL Server 2012 Express is 10 GB. It is the ...
- 6,347
5
votes
2
answers
70k
views
Cluster network name resource 'Cluster Name' failed registration
I have a fail-over cluster set between two Windows Server 2016 machines, and I'm seeing errors regarding the DNS record, both for the cluster itself and for any listener I try to add in SQL high ...
- 51
5
votes
2
answers
229
views
Virtualized SQL Server Memory Oddity
I've not seen this before, though perhaps it is common. I am looking at a virtualized (VMWare 5.5) SQL Server (2008R2 on Windows 2008 R2). What I am seeing is that in Task Manager*, sqlserver.exe is ...
- 427
5
votes
1
answer
7k
views
Diagnosing slow Always On commits
Two node Always On availability group, one synchronous replica.
My synchronous replica falls out of sync very regularly. I see a pattern in which, when a log backup occurs on the secondary replica a ...
- 1,490
5
votes
1
answer
1k
views
SQL Server 2014/2016 (Win2K12R2) and Winsock limits - how to cope?
We're experiencing a problem with connections to SQL Server and after a week of digging through I was able to pinpoint it to Winsock limits. Here's the description:
We have SQL Server 2014 (and 2016) ...
- 151
5
votes
1
answer
562
views
SQL Server 2012 mirror setup - how to reduce transaction log files [duplicate]
We just upgraded our Windows Server 2003\SQL Server 2005 setup to Windows Server 2012/SQL Server 2012. Both configurations have a mirror with NO witness server.
On the old setup the transaction logs ...
- 225
4
votes
1
answer
4k
views
Can't restore my distribution DB postgres 9.2 backup into my staging DB postgres 9.3
I keep getting this pg_restore: [archiver] did not find magic string in file header when i execute a pg_restore -Fc -U "username" -d "dbname" "filename".dmpon my staging DB.
These DB are running on ...
- 143
4
votes
3
answers
3k
views
SQL Server - Benefits of splitting databases across different logical drives
We're about to start a project to migrate a large DWH to new physical servers in a new data centre. The current server spec is SQL Server Enterprise 2016 SP2 running on Windows 2012 R2. The new ...
- 326
4
votes
3
answers
883
views
Is it possible to setup failover clustering between a 32 bit instance and a 64 bit instance?
I am attempting to setup a couple of virtual machines in my lab for testing failover clustering on SQL Server 2008 and Windows Server 2008.
One of the hosts I have is not capable of running a 64 bit ...
- 69.5k
4
votes
1
answer
1k
views
How do I prevent my Windows Server from being automatically rebooted by SQL Server updates?
Some SQL Server updates have happened outside the maintenance window, which have caused the server to be rebooted. How can I stop this from happening again in future?
Below is what I can see when ...
- 423
4
votes
1
answer
186
views
Is it possible to connect MS SQL Server Express 2012 through DAC Connection?
Is it possible to Connect MS SQL Server 2012 Express Through DAC. After moving from SQL Server 2012 Enterprise to MS SQL Server 2012 Express, some performance problem were there. When i have checked ...
- 6,347
4
votes
1
answer
1k
views
Microsoft SQL server storage best practice on Windows server vm with hybrid storage
I have a windows server VM, with a combination of HDD and SSD storage, the SSD storage capacity is limited to 50 GB, but HDD storage capacity is high.
What is the best way to share these storages to ...
- 251
4
votes
2
answers
9k
views
Cannot install Sql Server 2019 on Windows Server 2022
On a brand new install of Windows Server 2022 standard, I am trying to install SQL Server 2019.
I downloaded the eval version, put my key in and proceeded to install the Database Engine. Default ...
- 41
4
votes
1
answer
422
views
MySQL 8.0 Replication filters lost between restarts
I don't know if I fell on a bug or a feature, I read the documentation several times but haven't found the information.
I have two MySQL servers, both on 8.0.15 and hosted on a Windows Server (x64). ...
- 143
4
votes
2
answers
1k
views
4 CPUs of 20 (NUMA node 0) Pegged at 100%
The previous Senior DBA left the company and I was made aware of a server which suffers from multiple problems, largely slowness (all the way from SSMS taking a long time to open, long running queries,...
- 811
4
votes
1
answer
1k
views
Multi Subnet Availability Group IP Requirement for Windows Failover Cluster
Does the Windows Failover Cluster for a multi-subnet SQL Server Availability Group require a static IP entry for each subnet?
The instructions I am finding for a Failover Cluster Instance (FCI) in a ...
- 43
4
votes
2
answers
1k
views
Patching strategy when Windows and SQL Server patches not applied for over 3 years
The company I'm at hasn't patched their production servers for a while, neither SQL 2012 or Windows 2012. When I say "for a while" I mean, well, actually "never" - no patches or updates since the ...
- 41
4
votes
1
answer
21k
views
SQL Server 2012 Reporting Services: "Unable to connect to the remote server"
I am trying to install SQL Server 2012 Reporting Services on Windows Server 2008, but all the web interface says after adding the feature and confirming all the default settings in Reporting Services ...
- 143
4
votes
1
answer
337
views
Active Directory Name Change
Our Active directory will change the accounts name for example John Doe [email protected] to [email protected].
My question is do I need to change all the SQL Logins individually or the person can login ...
- 1,019