Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

450 questions
35
votes
4 answers

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. Some observations I see: A query that took <5…
Jeff
  • 505
  • 1
  • 4
  • 7
20
votes
2 answers

The value could not be converted because of a potential loss of data

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 this problem on StackOverflow and DBA Stack…
Mathias Lykkegaard Lorenzen
  • 579
  • 2
  • 5
  • 13
13
votes
4 answers

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 2000 to SQL Server 2014. We can afford to buy…
Yoshiaki Fujita
  • 131
  • 1
  • 1
  • 3
13
votes
2 answers

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. The duration of the job is: 00:00:00 Line 46 of this…
user507
13
votes
3 answers

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 the job scheduler in pretty much every case,…
SqlRyan
  • 1,206
  • 2
  • 17
  • 24
12
votes
3 answers

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 after the new domain is joined?
BrianCooksey
  • 483
  • 2
  • 4
  • 14
10
votes
2 answers

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 (c) Microsoft Corporation Standard Edition…
Łukasz Kastelik
  • 1,405
  • 2
  • 14
  • 23
10
votes
4 answers

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] = None H: [LOGS] = None T: [TEMP] = None There is a…
Drewbert
  • 131
  • 1
  • 8
10
votes
2 answers

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:\ProgramData\Data. Can you please help me, anyone ?
user73314
  • 101
  • 1
  • 1
  • 3
9
votes
1 answer

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 (Configufation Manager shows the service as stopped) the…
SE1986
  • 2,142
  • 4
  • 30
  • 61
8
votes
1 answer

'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, using Tools -> Connect to database..., I can enter…
boggy
  • 427
  • 2
  • 7
  • 14
8
votes
1 answer

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 inconsistent data, but I need to minimize the downtime. …
schneiju
  • 131
  • 1
  • 1
  • 5
8
votes
1 answer

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 a result is that we have massive spikes in…
Zane
  • 3,530
  • 3
  • 25
  • 45
8
votes
3 answers

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. In the past we've incrementally added RAM and CPU…
Sir Swears-a-lot
  • 3,253
  • 3
  • 30
  • 48
8
votes
1 answer

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. Using SQLCMD.exe on a remote machine: sqlcmd -S…
Mike Christensen
  • 335
  • 2
  • 3
  • 15
1
2 3
…
29 30