Automating "picture" of server performance

Hi all

I need to do the following using the performance monitor tool.

Im monitoring the %cpu used, transaction/sec and page/sec of a server using the perfomance monitor.

What i would need to do is to monitor all these information in a log that will reset himself once it has reached its maximum size limit. I also need to be able to take a "screenshot" of what was in the log when it became full but i cannot simply save the file because it would use too much space in the long run.

Is there a way for me to automating this information and make it so that each time the log become full i can take a screenshot (By that i mean getting a image of the information under the form of a graphic) of what was inside the log before it restart?

Ask if you need more precision

Dale

If you can't save the file, you probably can't save a graphic that would include everything and all the details in the file.

You can automate perf mon and dump it to a CSV. But if you tried to create a screenshot that shows all the details of all the info in the CSV and save all of those, it's likely not going to save space. Maybe you should look at the interval you are using in perf mon. Or save the file somewhere off the server if it's just space on the server itself. Or load the csv files into a table in a database. I just am not following the whole screenshot concept. It's not going to be that useful in analysis to have a ton of screenshots to look through.

-Sue

|||

I need those to help determine the best moment of the week to monitor the system through a server sided trace.

I think the best will be to just keep all the log and extract the information i want from it at the end of the week.

automatically set processor affinity mask not checked

I take that by default for multi CPU machines, the "Automatically set
processor affinity mask for all processors" is checked in the properties of
the server in SQL 2005
My question is, if its not checked, what does that mean and what are the
pros and cons of it ?
So how can I check which processors are being used ?
If I look at the processors, all the processors are checked ?
So in essence, is it the same thing as if this setting was checked ?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:A1C1FE69-965D-4A38-B1B8-D61E5CB38CD0@.microsoft.com...
> Check out sp_configure and the "affinity mask" option. Checking the
> checkbox means 0 (all processors can be used). Un.checking this box is
> setting it to some other bitmask, where you specify which processors can
> be used.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Hassan" <hassan@.test.com> wrote in message
> news:OPwvm$7VIHA.2304@.TK2MSFTNGP06.phx.gbl...
>

automatically set processor affinity mask not checked

I take that by default for multi CPU machines, the "Automatically set
processor affinity mask for all processors" is checked in the properties of
the server in SQL 2005
My question is, if its not checked, what does that mean and what are the
pros and cons of it ?Check out sp_configure and the "affinity mask" option. Checking the checkbox means 0 (all processors
can be used). Un.checking this box is setting it to some other bitmask, where you specify which
processors can be used.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Hassan" <hassan@.test.com> wrote in message news:OPwvm$7VIHA.2304@.TK2MSFTNGP06.phx.gbl...
>I take that by default for multi CPU machines, the "Automatically set processor affinity mask for
>all processors" is checked in the properties of the server in SQL 2005
> My question is, if its not checked, what does that mean and what are the pros and cons of it ?
>
>|||So how can I check which processors are being used ?
If I look at the processors, all the processors are checked ?
So in essence, is it the same thing as if this setting was checked ?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:A1C1FE69-965D-4A38-B1B8-D61E5CB38CD0@.microsoft.com...
> Check out sp_configure and the "affinity mask" option. Checking the
> checkbox means 0 (all processors can be used). Un.checking this box is
> setting it to some other bitmask, where you specify which processors can
> be used.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Hassan" <hassan@.test.com> wrote in message
> news:OPwvm$7VIHA.2304@.TK2MSFTNGP06.phx.gbl...
>>I take that by default for multi CPU machines, the "Automatically set
>>processor affinity mask for all processors" is checked in the properties
>>of the server in SQL 2005
>> My question is, if its not checked, what does that mean and what are the
>> pros and cons of it ?
>>
>|||> So how can I check which processors are being used ?
Configured to be used, or actually doing some work at a particular point in time? For the later, you
can for instance use Task Manager. For the former, check your sp_configure setting.
> If I look at the processors, all the processors are checked ?
> So in essence, is it the same thing as if this setting was checked ?
There is a slight difference between having all checked and the checkbox not checked (the later is
value 0). SQL Server has as many schedulers as processors. With value 0, a scheduler isn't tied to a
particular processor. With anything but 0, each scheduler is tied to a particular processor. If you
want to dig more into schedulers, threads, workers etc, check out Kalen's Inside SQL Server 2005
book.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Hassan" <hassan@.test.com> wrote in message news:eMOEut8VIHA.5132@.TK2MSFTNGP02.phx.gbl...
> So how can I check which processors are being used ?
> If I look at the processors, all the processors are checked ?
> So in essence, is it the same thing as if this setting was checked ?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:A1C1FE69-965D-4A38-B1B8-D61E5CB38CD0@.microsoft.com...
>> Check out sp_configure and the "affinity mask" option. Checking the checkbox means 0 (all
>> processors can be used). Un.checking this box is setting it to some other bitmask, where you
>> specify which processors can be used.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Hassan" <hassan@.test.com> wrote in message news:OPwvm$7VIHA.2304@.TK2MSFTNGP06.phx.gbl...
>>I take that by default for multi CPU machines, the "Automatically set processor affinity mask for
>>all processors" is checked in the properties of the server in SQL 2005
>> My question is, if its not checked, what does that mean and what are the pros and cons of it ?
>>
>>
>sql