SQL Homework – October 2021 – What can you tell me about the server your SQL Server instance is on?

Leave a comment

October 5, 2021 by Kenneth Fisher

Here are some really common questions I get:

  • How many CPUs does ServerA have?
  • How much memory does ServerA have?
  • What’s the port for ServerA\InstanceA?

So this month I’d like you to answer a few questions along those lines. Find out the following information for one of your servers.

  • How many CPUs does the server have?
  • How much memory does the server have?
  • What are the IP(s) and Port(s) for the instance?
  • Is the instance using dynamic ports?
  • What service accounts are being used for the instance?
    • SQL Instance
    • Agent
    • FullText
    • Analysis Services
    • SSIS
    • Anything I might have missed?
  • When was the instance last restarted?
  • Is the instance clustered?
  • Is this a virtual machine?
  • And again, feel free to include anything I might have missed or that you feel like might be helpful. Particularly if you’ve been asked for the information recently.

Ok, now that you know where to find this type of information, automate it. Write a SQL script to pull all of this information together. Now do it in Powershell.

Now for the pièce de résistance! Put together something that will collect all of this information for a list of instances. Collect the data for all of your instances and ask your manager if this information would be helpful.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: