prem.m38 (10/3/2016)

---

I want to configure Log shipping for 7 TB database in sql server 2014(EDW environment) and we are using commvault as a backup tool, weekly full backup happens on...

I am not saying what you are seeing is related to a bug....

There are a few reasons for this. But sorry, I'm not going to waste my time helping you decipher it while you are on RTM of SQL 2014 and thus...

prem.m38 (9/28/2016)

---

Hi Kevin,

there is no network issues ,there is no load at all on the server at present we are not using for reporting too.Logs got restored successfully for 3...

Looks like you are losing a connection. Perhaps something is forcibly closing them. Or your server is undergoing some weird overload. I wonder there is more than one restore happening...

Looks like medical records data.

I love the smell of healthcare data in the morning. Smells like ... KAAAACCCHHHIIIIINNNNNGGGGG!!!! 😀

Seriously though, you should be able to find out who is...

if you search ola sql server maintenance, guess who pops up at the very top of the list. :hehe:

page853 (9/24/2016)

---

Thanks Guru

Pretty much confirmed what i thought.

Before i left HP ( on the Rolls Royce account in Derby) i set up some perfmon monitor collections, and wrote it up,...

You CAN certainly run a 75GB database just fine on 32GB. But often you CAN NOT. If you know what you are doing and don't observe any issues that are...

1) Why limit yourself to 32GB RAM? SQL 2014 Standard Edition can hold 128GB

2) Why mess with tempdb at all? Have you identified tempdb allocation issues as a cause of...

Since it is "very frequent" blocking, I would just use sp_whoisactive. Given AlwaysOn is in play if it is synchronous that could have an effect. No matter the cause sp_whoisactive...

page853 (9/23/2016)

---

Thnks.

So in order to find out how the instance is performing

a) do i need to use Perfmon - and if so which parameters do i need to monitor? (...

page853 (9/22/2016)

---

Hi thanks

unfortunately I can't put anything on the server that isn't cleared by the institution I work for.

We're just eyeballing task manger - but I'm not sure that...

page853 (9/22/2016)

---

Hi TheSQLGuru - thanks

Performance is slow - but I think the 3rd party app that uses the SQL server runs slow.

We don't run queries as such, but the 3rd...

page853 (9/22/2016)

---

Hi

we have WS 2012 which has

WS2008R2/3 processors/6 GB RAM

On it we have SQL server 2012. Currently we have 30 (yes 30) SQL DB's on there. It's our...