No announcements
-
0 VotesLogShipping Error (out of sync)
Hi all, I am having this error on the primary server LSAlert job: The log shipping secondary database SERVER.DATABASE has restore threshold of 45 minutes and is ...Unanswered | 1 Replies | 45 Views | Created by George Waters - Friday, December 08, 2017 6:40 PM | Last reply by Gnana Balaji Kanagaraj - 59 minutes ago
-
0 Votes
how to add linked server with IP address from out of local network
I would like to add a linked server from out of local network with IP address. i got IP address of the server i want to link it, and also user & password, i ...Unanswered | 2 Replies | 245 Views | Created by masoud sedighy - Saturday, December 09, 2017 6:38 AM | Last reply by Gnana Balaji Kanagaraj - 1 hour 6 minutes ago -
1 Votes
Difference between dbcc inputbuffer(spid) and select text from sys.dm_exec_sql_text(sql_handle | plan_handle)
Hi All, dbcc inputbuffer(spid) is one of the basic command i used to whenever i used to start with a performance issue , so misunderstanding here is the output of dbcc ...Unanswered | 4 Replies | 42 Views | Created by Nithin Tomson - 6 hours 10 minutes ago | Last reply by Uri Dimant - 5 hours 34 minutes ago -
0 Votes
DBCC commands on SQL Azure db
Hi All, For tuning poorly performing query on a Testing server or local SQL instance on a Laptopn, we used to run below 2 ...Unanswered | 2 Replies | 52 Views | Created by Samantha v - 7 hours 39 minutes ago | Last reply by Nithin Tomson - 5 hours 51 minutes ago -
0 Votes
Not work Database mail
Hi, I have sql server 2016 with not working databse mail. I configured Database mail component by the wizard, but test email not send (the same configuration on ...Answered | 11 Replies | 1499 Views | Created by arch.us-prm.ru - Monday, February 06, 2017 6:43 PM | Last reply by AndreToerien - 23 hours 56 minutes ago -
1 Votes
Deadlock on page lock during two simple delete commands
Hi, I fight with deadlocks. I can't understand why this occours. This is my deadlock graph: Here is my MS SQL server log: 12/07/2017 ...Proposed | 2 Replies | 53 Views | Created by talby_sk - Friday, December 08, 2017 8:58 AM | Last reply by JRStern - Friday, December 08, 2017 5:11 PM -
0 Votes
while avamar backup running (third party tool),,, Frequently Blocking is occuring on the SQL server 2005.
Hi All, One of my server is getting the below blocking error Our backup team is using AVAMAR tool on the veritas cluster server ...Unanswered | 2 Replies | 58 Views | Created by annamarajuphani - Friday, December 08, 2017 8:25 AM | Last reply by annamarajuphani - Friday, December 08, 2017 1:27 PM -
1 Votes
Switch from Full Recovery mode to Simple Mode
Switch from Full Recovery mode to Simple Mode in SQL SERVER 7.0 try to do it with the script ALTER DATABASE DB SET RECOVERY [SIMPLE] ...Proposed | 5 Replies | 111 Views | Created by Jason Cubillos - Thursday, December 07, 2017 3:25 PM | Last reply by Erland Sommarskog - Friday, December 08, 2017 12:29 PM -
0 Votes
syspolicy_purge_history failed. Proceess Exit Code -1073741790
Hello. MSSQL 2014 Enterprise (12.0.5553.0) syspolicy_purge_history failed with Proceess Exit Code -1073741790 (step 3). I try to ...Unanswered | 5 Replies | 86 Views | Created by Alex DR - Thursday, December 07, 2017 1:35 PM | Last reply by Alex DR - Friday, December 08, 2017 9:51 AM -
1 Votes
sp_server_diagnostics system keeps showing warning and cpu usage around 60%
system: Collects data from a system perspective on spinlocks, severe processing conditions, non-yielding tasks, page faults, and CPU usage. This information is produces an overall health state ...Proposed | 3 Replies | 91 Views | Created by George Zhou - Tuesday, December 05, 2017 10:06 PM | Last reply by Hannah Yu - Friday, December 08, 2017 9:21 AM -
0 Votes
TDE performance test
Hello On the same SQL instance (SQL Server 2016 (SP1) Enterprise Edition) i put two identical dbs (restored from production enviroment and anonimized) - named DB and ... -
0 Votes
Restore full backup followed by a differential backup
I am trying to restore a full backup to an existing database with norecovery which is to be followed by restoring a differential backupwith recovery. But the first step restore of full ...Answered | 5 Replies | 83 Views | Created by Curendra - Friday, December 08, 2017 6:10 AM | Last reply by Teige Gao - Friday, December 08, 2017 8:45 AM -
0 Votes
I cannot start the SQL Server 2008r2 Service on my Windows 7 laptop.
Below is the text of my Online Chat regarding this issue: *** *** *** [11/27/2017 23:49:23 GMT]Thank you for contacting Microsoft Support. I ...Unanswered | 11 Replies | 188 Views | Created by Charles H Irwin - Tuesday, November 28, 2017 11:06 PM | Last reply by Hannah Yu - Friday, December 08, 2017 8:26 AM -
0 Votes
Application can not insert records on to database during backup job is runing
Hi we have an application that write data on to sql database. yesterday there are 2 records that did not get written to the database. I check and it happens ...Unanswered | 8 Replies | 81 Views | Created by Kau Lee - Thursday, December 07, 2017 6:17 PM | Last reply by Erland Sommarskog - Thursday, December 07, 2017 10:02 PM -
0 Votes
unable to access SQL Server 2005 Management Studio, Error 233
I can't access SQL Management Studio and getting this error message Cannot connect to localhost. Aconnecton was successfully established with the server, but then an error occured ...Unanswered | 2 Replies | 44 Views | Created by Bundoo - Thursday, December 07, 2017 7:12 PM | Last reply by Erland Sommarskog - Thursday, December 07, 2017 9:58 PM -
0 Votes
why query runs faster on dev?
I run the same query on a live environment and it takes 5,6 minutes. I run it in a dev environment (that has a lot less capacity) and it runs in seconds! ...Answered | 2 Replies | 57 Views | Created by maca128 - Thursday, December 07, 2017 8:08 PM | Last reply by Erland Sommarskog - Thursday, December 07, 2017 9:55 PM -
0 Votes
alter statement failed because the operation cannot be performed online on a table with a columnstore index
Hi All, I have SQL Server 2016. Implemented Clustered columnstore for one of the database. Same table also have Unique Non Clustered B-Tree ...Proposed | 3 Replies | 76 Views | Created by princerastogi - Thursday, November 30, 2017 1:22 PM | Last reply by Olaf Helper - Thursday, December 07, 2017 6:19 PM -
5 Votes
SQL Server 2016 memory pressure leads to the plan cache clearing
Two weeks ago we migrated into SQL Server 2016 SP1 CU3 (previously our app was using SQL Server 2014 SP2). The application hasn't been upgraded or changed nor the workload has ...Answered | 30 Replies | 887 Views | Created by Grzegorz Opara - Thursday, August 03, 2017 3:19 PM | Last reply by Tom Phillips - Thursday, December 07, 2017 12:40 PM -
0 Votes
improving performance query
Hi experts, I am trying to improve this query, which is like: select Into #temp1 From ...Answered | 7 Replies | 117 Views | Created by maca128 - Wednesday, December 06, 2017 4:03 PM | Last reply by Erland Sommarskog - Thursday, December 07, 2017 12:29 PM -
0 Votes
storage optimizer runs every 30min on SQL AlwaysOn VMs
hello everyone, we have some virtual Windows Server 2012 R2 based SQL AlwaysOn Servers (2016 SP1) where we can see following events logged to the system ...Answered | 2 Replies | 59 Views | Created by Ville87 - Thursday, December 07, 2017 6:40 AM | Last reply by Ville87 - Thursday, December 07, 2017 10:21 AM - Items 1 to 20 of 32433 Next ›
No announcements
