Hi Sal, that error message usually indicates that something is still accessing the .bak file the same time you are running the restore command. Do you see any...

Are you are calling the mail stored procedure while connecting to the msdb database like this in your job step?

USE msdb

GO

EXEC sp_send_dbmail

Hi, so when the t-sql is scheduled and exists in a Sql Server job, regardless of the owner of the job or other permissions, the Sql Server agent account needs...

Adding to the comments and you may already know this - As far the shared storage for the cluster is concerned, you will obviously need new separate LUNS for your...

Hi, SQL Server Integration Services is not instance-aware; i.e. you can only install a single instance of the Integration Services service on your server. However, there is a work...

Ok, so CXPACKET waits are at the top of your waits and account for over 50% of the total waits. What is your MAXDOP (Max degree of Parallelism) and...

Ok, does not appear to be any cache bloat. How are your WAITS? Please run below and post:

WITH [Waits] AS (SELECT ...

How much of the plan cache is being used for AdHoc queries? Can you post the results of this query?

SELECT objtype AS [CacheType],

COUNT_BIG(*) AS [Total...

Hi Jay,

As a start, I would go out and download the latest version of Management Studio (2016) from Microsoft and install it on the workstation, removing the existing one first...

Try restarting the mirroring endpoints:

-- To find out the name of the endpoint - execute from the primary

SELECT * FROM sys.endpoints

ALTER ENDPOINT Mirroring STATE=STOPPED

ALTER ENDPOINT Mirroring STATE=STARTED

If communication between the...

Hello, thinking the process would be similar to this:

1) Windows team clones the existing Sql Server with a new (temporary) server name

2) You, the dba, runs the code you have...

Are you meaning something like this?

Select *

,dopc.cntr_value / 1024 As 'Total (MB)'

From sys.dm_os_performance_counters dopc

Where dopc.counter_name In ('Target Server Memory (KB)', 'Total Server Memory (KB)')

You should be able to shrink the log file for tempdb just as you would normally as any other database:

USE [tempdb]

GO

DBCC SHRINKFILE ('templog', 2048)

GO

If you have tried this and it...

Hi Diane, thought I would take a stab at answering some of your questions...

1. Is it better to send out the email messages using the database mail on sql server...

Hi, to rule out SSMS being the issue, are you able to restart Sql Server via any other methods? For example - services.msc if not a clustered instance of...