recession

Not going to stand one out from the other, they are all good tools, they all monitor, they all do the same thing, just in different ways and allow for...

Mixed, as detailed, try them all out, they all do the same but different, they...

Take a look at

Red-Gate SQL Monitor

Idera Diagnostic Manager

Dell Spotlight on SQL Server

Dell Foglight

SQL Sentry Performance Adviser

ApexSQL Monitor

Prices vary, and will vary on bulk purchasing so prices are never usually given...

Assuming you want to create the script in SSMS on the same server where the backups are taken from, take a look at the backup tables in MSDB to dynamically...

Remove the ' from around the hex value

select * from sysjobsteps where job_id = 0xBEB303926F0CE848BA3F9858417DB773

The hex value is the GUID converted to hex and binary is passed in without quotes...

Stuart Davies (12/11/2015)

---

Desmond

Then monitor what is using TempDB and define if this is normal or not.

If not go speak to the person who is causing the issue and work with them to...

Yes defiantly looks like a double hop issue.

Check with your domain admins, that the SQL Server accounts have trusted for delegation rights and that the correct SPN's have been set...

Log growth is normal.

Is the growth rate your seeing normal, who knows.

You will need to monitor whats using TempDB to see whats causing the log growth, maybe you had a...

Gazareth (12/10/2015)

---

richardmgreen1 (12/10/2015)

---

We aren't using it for failover.

The mirrors will be snapshotted for use in reporting.

We need the data to run various reports on (that's on thr BI Edition server).

The...

Ah ok, that makes more sense.

In theory it should work, but as John has already mentioned mirroring is now a depreciated feature.

I would take a look at Log Shipping instead...

dprasannain (12/10/2015)

---

create table #emps (EN varchar(10))

insert into #emps values

('A'),

('B'),

('C'),

('D')

DECLARE @Names VARCHAR(8000)

SELECT @Names = COALESCE(@Names + ', ', '') + char(39)+en+char(39)

FROM #emps

print @Names

-- This query does'nt return any values when...

Post the full code you have executed, that code isn't in my snippet so you have modified it some how to work with your environment

It all comes down to how you want to handle nulls

First COALESCE returns a null due to the null in the table

Second COALESCE returns a string but with *** in...