gaojia2004 (2/9/2015)

---

first, you should find the query, and confirm with your client, then kill them.

I often find the most longest query first, and check if there is any optimization I...

Thanks Gila.

Yes, I have already conveyed to them. I even passed them the queries they need to look at long ago.

Think its done with some pathetic design and coding. All...

Thanks..

It's production box, so wanted to check if any workaround without running setup again.

Perry Whittle (2/3/2015)

---

Are you...

Yes, it runs every weekend.

Thanks Igor Micev and CodedSteve.

No much free space in the DB, so shrinking will not release any space to drive.

Shrinking log file is also not an option as log...

Thanks !.

select * from sys.dm_os_performance_counters

doesn't return anything. No records. How to go about it now ?

Note :- As soon we installed SQL Server, wintel had upgraded OS from...

RAM is 2 GB ?

MS recommendation is 4GB or more I believe.

Volume Shadow (Copy) Service

It's what's used to take 'snapshot'-type backups of SQL databases. The service communicates with SQL to quiesce the IOs, then 'snaps' the files to the backup.

If it's...

Confirmed they haven't configured anything.

I checked it further, found device_type = 7 and hence assume its the VSS backup updating backupset table in msdb database (Not sure if the actual...

OK.. Any attachment in the mail ? Recently I was facing some issues with attachment.

Telnet to mailserver/port is working ? Firewall is open ?

SQL Server name is nothing but your instance name is it...

..Hope you are entering "server name\instance, 1434".

..Working with IP by any chance ?

It's restart of SQL Server service.

From the same link........

How to apply the change

The phrase "Log out and then log back in for this change to take effect." should...