SQL Server Performance Monitor Objects

Published On: 2019-05-13By:

Monitoring SQL Server Performance Monitor objects (Perf Mon for those in the know) can be an important part of monitoring your SQL Server instance. Finding information about the performance monitor objects that SQL Server exposes can be tricky, even though the SQL Server Project Team can documented what these objects all mean.

You can find the documents about the SQL Server Perf Mon objects online on the Microsoft docs website.

If you haven’t had a chance to check it out, I’d very much recommend it. If you are looking for which objects you should be monitoring this can answer a lot of questions for you.

If you need more help past that, let us know, we can help you out.

Denny

 

The post SQL Server Performance Monitor Objects appeared first on SQL Server with Mr. Denny.

Contact the Author | Contact DCAC

Changing the Time Zone of Azure VMs

Published On: 2019-05-06By:
When you create a VM in Azure it’s always set to the UTC timezone. There are some times when that doesn’t work and it needs to be set for a specific time zone. In a perfect world, the apps could be fixed so that they could deal with the fact that the servers are now in UTC instead of the local timezone. But this isn’t always possible, and the server’s time zone needs to be changed. The “normal” process to change the timezone for a Windows server doesn’t work as expected. You can change the time zone by right-clicking on the clock and selecting “Adjust Date and Time”. If you change the time zone here, it doesn’t actually do anything (at least it didn’t when I did it).  It may also change for a short period of time and then revert back to UTC. If you use PowerShell to change the timezone the change will stick, even if the VM is deallocated and reallocated. First, we need to see what the options are for changing the timezone.  We can see that by running the Get-TimeZone cmdlet. Get-TimeZone -ListAvailable If a list of every time zone possible isn’t helpful (and it probably isn’t) you can filter the list down as you probably know the name of the time zone you’re looking for.  My specific client needed a server created in the Pacific Time Zone, So I filtered it down by the word Pacific. Get-TimeZone -ListAvailable | where ({$_.Id -like "Pacific*"}) Second, we then use the cmdlet Set-TimeZone to change the time zone of the VM.  You’ll want to put the ID from the Get-TimeZone cmdlet into the ID parameter of the Set-TimeZone cmdlet. Set-TimeZone -Id "Pacific Standard Time" Denny The post Changing the Time Zine of Azure VMs appeared first on SQL Server with Mr. Denny. Contact the Author | Contact DCAC

American Business Awards® Taps DCAC Winner in Multiple Technology Categories

Published On: 2019-05-02By:

OCEANSIDE, Calif., May 2, 2019 /PRNewswire/ — Today, Denny Cherry & Associates Consulting (DCAC) proudly announced that after evaluating more than 3,800 applicants, the American Business Awards® has tapped DCAC a winner in three of their most competitive categories:

  • Technical Innovation of the Year
  • Most Innovative Tech Company of the Year
  • Technical Professional of the Year



DCAC received a “Technical Innovation of the Year” award for their work designing a cloud-based database on behalf the Elisabeth Glaser Pediatric AIDS Foundation. The database enables real-time communication between EGPAF and 5,200 medical facilities in 15 African countries.

DCAC received a “Most Innovative Tech Company of the Year” award for their impressive portfolio of technology innovation in 2018, which included innovations for Fortune 500 companies, enterprise and small businesses, and nationally renowned non-profits.

A “Technical Professional of the Year” award was granted to globally renowned Microsoft MVP and DCAC Senior Consultant Joey D’Antoni, who took on the work of company founder Denny Cherry when he was placed on extended medical leave. In January and February of 2018 alone, D’Antoni flew 30,000 miles globally to ensure all DCAC client’s needs were met to the unparalleled standard of DCAC’s world-renowned reputation.

Founder Denny Cherry commented, “On behalf of DCAC, I’d like thank the American Business Awards® for all of this overwhelming amount of recognition, especially in the face of such impressive competition. We’d also like to share the “Technical Innovation of the Year” award with the Elisabeth Glaser Pediatric AIDS Foundation, without whom this award wouldn’t be possible. Finally, I’d like to thank and congratulate my best friend and Senior Consultant, Joey D’Antoni for all he did when I was on medical leave. It’s one feat to be an expert in your field, it’s exponentially more difficult to act and do the work of two experts, and he did. Thank you all, we look forward to another great year at DCAC!”

DCAC received the Bronze in each category.

About Denny Cherry & Associates Consulting

Award-winning Microsoft Partner and Gold Platform certified Denny Cherry and Associates Consulting assist companies with reliably attaining IT goals such as Azure Migration, HA, scalability, SQL Server virtualization and acceleration, while finding ways to save on costs. With clients ranging from Fortune 50 corporations to small businesses, their commitment to each is the same: to provide a deft, high-speed IT environment that maximizes every aspect of their platform: from architecture, to infrastructure, to network.

SOURCE Denny Cherry & Associates Consulting
Related Links

http://www.dcac.com

Contact the Author | Contact DCAC

Data Platform Summit 2019

Published On: 2019-04-29By:

I’m thrilled to be able to announce that I’m presenting two pre-cons at the Data Platform Summit 2019 in Bangalore, India. The first all-day session that I’m giving is “Azure Infrastructure” which I’ll be presenting on August 19th, 2019. The second that I’m presenting is “HADR – SQL Server & Azure” which I’ll be presenting on August 21st, 2019.

Azure Infrastructure

In this daylong session, we’ll review all the various infrastructure components that make up the Microsoft Azure platform. When it comes to moving SQL Server systems into the Azure platform having a solid understanding of the Azure infrastructure will make migrations successful and making support solutions much easier.

Designing your Azure infrastructure properly from the beginning is extremely important. An improperly designed and configured infrastructure will provide performance problems, manageability problems, and can be difficult to resolve without downtime.

With the introduction of multiple Azure data centers now available in India, many companies will begin moving services from data centers into the Azure, and a solid foundation is a key to successful migrations.

HADR – SQL Server & Azure

In this session, we’ll walk through the needs and process to set up a Hybrid Always On Availability Group using servers on premises for production and servers in Azure for Disaster Recovery.

We’ll be looking at high availability and disaster recovery tuning requirements, troubleshooting steps and various best practices for Always On Availability Groups in SQL Server 2017.

Why you want to be there

These two all-day sessions will both be a fun-filled day of learning that you won’t find anywhere else. Be sure to register now, as prices go up each month (the next price increase is in just a couple of days).

Denny

The post Data Platform Summit 2019 appeared first on SQL Server with Mr. Denny.

Contact the Author | Contact DCAC
1 2 3 343

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers    VMWare Partner
Microsoft Certified Master    Microsoft MVP