March 23, 2016 at 1:32 am
Hi All,
I want to prepare the database that needs to be capture Memory,CPU usage and disk space utilization from all the servers in domain.
Could you please share the process and scripts for the same.
March 23, 2016 at 7:23 am
New persopn (3/23/2016)
Hi All,I want to prepare the database that needs to be capture Memory,CPU usage and disk space utilization from all the servers in domain.
Could you please share the process and scripts for the same.
There is nowhere near enough information here. Do you want to capture this data on a regular basis? How do you plan on doing that? What exactly are you trying to capture? The current point in time utilization of all this info? Start by providing enough details for somebody to help and we will help get you started.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 23, 2016 at 7:38 am
I want to capture the CPU and memory and disk utilization on hourly basis through job are through any custom scripts.
And all these results needs to be stored in database tables. We are going use this results for Capacity planning.
March 23, 2016 at 7:48 am
New persopn (3/23/2016)
I want to capture the CPU and memory and disk utilization on hourly basis through job are through any custom scripts.And all these results needs to be stored in database tables. We are going use this results for Capacity planning.
OK so what have you done so far? Do you have a query that gets the data you want to see? What about the CPU, memory and disk utilization to you want to get? Is this across an entire server or a specific database? Do you need to capture more than 1 instance of sql?
As a starting point I would figure out what data you need to capture and then create the table to hold it. Somewhere before that step or immediately after you need to figure out the query. Then extend it to capture multiple databases or instances or servers or whatever.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 23, 2016 at 8:18 am
This not for one server we have total 2000 server and we have to capture it for all the server and we have to store that information in one database.
We have to capture the below things when the job is executing below information needs to be captured
Occupied Memory
Disk space availability
Cpu Utilization
March 23, 2016 at 8:47 am
New persopn (3/23/2016)
This not for one server we have total 2000 server and we have to capture it for all the server and we have to store that information in one database.We have to capture the below things when the job is executing below information needs to be captured
Occupied Memory
Disk space availability
Cpu Utilization
OK. I am NOT going to do this for you. You have not demonstrated any level of effort here other than asking for somebody to do this for you. Have you tried to see if you can find this information? Have you created a table to hold the results? You might want to add a column for server name. There are so many things here that probably seem simple but they just aren't clear. For example, do you want occupied memory of the server or just what sql server is using? For disk space do you want total space on the server? Which drive(s)? Or are you talking about how much space is in the data and log files currently? Or how much space they currently consume minus the max allowed size? Are you beginning to see how much you have left to interpretation here?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 23, 2016 at 8:57 am
New persopn (3/23/2016)
This not for one server we have total 2000 server and we have to capture it for all the server and we have to store that information in one database.We have to capture the below things when the job is executing below information needs to be captured
Occupied Memory
Disk space availability
Cpu Utilization
Allthough I fully agree with Sean's reply, there is one thing he left out.
If you want to monitor 1000 servers, then stop doing this manually right away. Get your boss to give you a budget and then invest in one of the many third-party monitoriing solutions out there on the market. Each of them has 1000's of man hours invested and will give you much more and much more useful information, in a much easier to use way, then anything you could ever write yourself.
March 24, 2016 at 4:16 pm
If you want to monitor 1000 servers, then stop doing this manually right away. Get your boss to give you a budget and then invest in one of the many third-party monitoriing solutions out there on the market. Each of them has 1000's of man hours invested and will give you much more and much more useful information, in a much easier to use way, then anything you could ever write yourself.
+1
Why are you re-inventing the wheel? There are so many products to pick from.
March 26, 2016 at 12:16 pm
Yes i dont have any script for capturing the details for 1000+ servers, i can handled for one sever.
Here i am not getting any idea because for these many servers we cant able to capture the information without connecting to server physically
That
March 26, 2016 at 12:18 pm
Due to above reason i can't able to find the automation scripts or powershell scripts
March 28, 2016 at 7:18 am
New persopn (3/26/2016)
Due to above reason i can't able to find the automation scripts or powershell scripts
So go purchase a package that does all of this already. You can either buy one or spend hundreds if not thousands of hours creating one.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply