Hi everyone,

I just wanted to let you know that a developer has now resolved this who has returned from leave. He knew the data better than me and used the...

Hi all,

Thanks for the replies so far. I am pretty new to the data as I have recently started in the role.

I think the code is derived from elsewhere, but...

Hi as1981.

Thank you for your response. I have tried that and that is good for that part of the query.

I shall try and work on the rest of it.

Thanks again.

George

Hi Nova,

Thanks for the script and your advice.

Much appreciated.

Kind regards,

George

I have now solved this issue.

select ticketid, statusnumber, statusdesc

from

(

SELECT

ticketid, statusnumber, statusdesc

row_number() over (partition by   ticketid  order by   statusnumber desc) as Seq

FROM

)t

Where Seq = 1

AND statusdesc IN...

My above query got formatted differently to what I expected.

There are only two Ticket IDs (1 and 2)

The first ticket ID has 3 statuses (1 - Open, 2 - Awaiting...

The following script seems to return what I require.

SELECT DB_NAME(bd.database_id) AS [Database Name],
rg.name as ResourcePool,
--COUNT_BIG(*) [Pages in Buffer],
--COUNT_BIG(*)/128 [Buffer Size in MB]
COUNT(*) * 8/1024.0...

Hi Jeff,

Thanks for your reply.

The DMV 'sys.dm_resource_governor_resource_pools' gives me some of the...

Hi Perry,

I just wanted to say thanks for the information you sent me. I have incorporated the scripts into my plan.

Kind regards,

George

Thanks Perry/Gail for the additional feedback.

Perry - I understand what you are saying. The databases that are being upgraded are all 2008r2, which means I should not need to run...

Thanks Gail.

Your reply provides me with the best supporting evidence I can give to my manager.

Many thanks.

George

Hi Grant,

Thank you very much for your reply. We are considering virtualization too, so that sounds like a good idea.

We do have affinity set for the processors, but I have...

Thanks Rich,

I will look at this article now.

Cheers,

George

Thanks for all your replies. There's some really good jobs here that I had overlooked.

I am just going through all of my servers and just want a number of...

Thanks for all your replies. They all make sense.

I will be making my recommendations tomorrow.

George