Lowell (4/3/2014)

---

Welsh to capture the code, for example, i decided the dmv's were not enough; not everything exists in the cache to check for performance issues.

Instead i started with a...

I do not like triggers either. Since it only fired when an abject was created, Dropped or modified it was not firing off that much. But now I know better.

I...

Lowell (4/3/2014)

---

Welsh to capture the code, for example, i decided the dmv's were not enough; not everything exists in the cache to check for performance issues.

Instead i started with a...

Jim_K (4/3/2014)

---

Hmm,

You wouldn't happen to be in a VM environment? I know there are some tools out there, such as Veeam, that will snapshot the database and record the fact...

I have to check with the Infrastructure Manager.

Thanks.:-)

They are doing the COMMVault Backups.

They are also doing snapshot of the Server every hour.

I failed to mention that this is a Great Plains Server which was managed by someone...

Thanks for the good advice.

I should have done more research before asking the question.

Upon my request for information the developer gave me the connection string and it was the wrong...

I regret the post.

I do everything to help my users.

I check the execution plans, add missing Indexes, rewrite the code, etc.

I would never do anything to hamper development or progress.

I...

ok, I appreciate the feedback.

Thanks.

I wish I could but I'm the DBA...

Thanks Jeff.

Fortunately the Backups did not hang last night.

I had this problem about a month ago on another server.

I was out on vacation but when I returned I discovered that...

Jeff Moden (3/19/2014)

---

Welsh Corgi (3/19/2014)

---

I have an Network Administrator running a 3rd Party Backup Utility on an instance of SQL Server.

On one instance the 3rd party Backups are hanging. Everything...

sqlbuddy123 (3/19/2014)

---

Check for any resource contention issues on the server that's causing this. Usually this occurs due to poor I\O. Try to find on what are the backups waiting for...

I currently have this code which works. It shows all of the jobs that are running but have not completed:

SELECT DISTINCT 'CYP_BI' AS Server,Jobs.Name AS...

HanShi (3/19/2014)

---

Adjust the WHERE clause to your own needs. I have chaged it (filter on name) to work in my own environment. It also filters to only display the jobs...