How to save and replay the performance counters created in Performance Monitor?

Hi,
I would like to get these saved and later analysed, but could not make it
done, help please.
Thanks in advance
FrankHi
In the properties page the is a data source setting where you can specify
current, log file or database
John
"Frank" wrote:
> Hi,
> I would like to get these saved and later analysed, but could not make it
> done, help please.
> Thanks in advance
> Frank
>
>|||Hi John,
Thanks for your reply, but I still don't know how to read it.
B/R
Frank
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:D683CA66-7D14-4A3B-98D0-4DF2B6590D00@.microsoft.com...
> Hi
> In the properties page the is a data source setting where you can specify
> current, log file or database
> John
> "Frank" wrote:
> > Hi,
> >
> > I would like to get these saved and later analysed, but could not make
it
> > done, help please.
> >
> > Thanks in advance
> > Frank
> >
> >
> >|||Hello Frank,
This is the common confusion that the first time users of Performance
Monitor have.
Just because you have a Performance counter file that does not mean it will
display the graph
when you open it.
You got to "Open" the file in Performance Monitor and then "Select" the
counters that you
want to be displayed.
Hope this helps !!
Gopi
"Frank" <wangping@.lucent.com> wrote in message
news:uhKf$yUJFHA.656@.TK2MSFTNGP14.phx.gbl...
> Hi John,
> Thanks for your reply, but I still don't know how to read it.
> B/R
> Frank
> "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> news:D683CA66-7D14-4A3B-98D0-4DF2B6590D00@.microsoft.com...
>> Hi
>> In the properties page the is a data source setting where you can specify
>> current, log file or database
>> John
>> "Frank" wrote:
>> > Hi,
>> >
>> > I would like to get these saved and later analysed, but could not make
> it
>> > done, help please.
>> >
>> > Thanks in advance
>> > Frank
>> >
>> >
>> >
>|||RGN,
Thanks so much, that help!
Frank
"rgn" <gopinathr@.healthasyst.com> wrote in message
news:epZbB2VJFHA.2756@.TK2MSFTNGP10.phx.gbl...
> Hello Frank,
> This is the common confusion that the first time users of Performance
> Monitor have.
> Just because you have a Performance counter file that does not mean it
will
> display the graph
> when you open it.
> You got to "Open" the file in Performance Monitor and then "Select" the
> counters that you
> want to be displayed.
> Hope this helps !!
> Gopi
> "Frank" <wangping@.lucent.com> wrote in message
> news:uhKf$yUJFHA.656@.TK2MSFTNGP14.phx.gbl...
> > Hi John,
> > Thanks for your reply, but I still don't know how to read it.
> >
> > B/R
> > Frank
> > "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> > news:D683CA66-7D14-4A3B-98D0-4DF2B6590D00@.microsoft.com...
> >> Hi
> >>
> >> In the properties page the is a data source setting where you can
specify
> >> current, log file or database
> >>
> >> John
> >>
> >> "Frank" wrote:
> >>
> >> > Hi,
> >> >
> >> > I would like to get these saved and later analysed, but could not
make
> > it
> >> > done, help please.
> >> >
> >> > Thanks in advance
> >> > Frank
> >> >
> >> >
> >> >
> >
> >
>|||Hi
If you create a new counter log, you can specify the file that log
should be written to. If you specify csv then you will get a readable
text file containing a row of headings for the counter names followed
by rows of timestamped values. Depending on what the counter is depends
on how you interpret it. The explain button in perfmon will give you
some details on what each counter means and what values to expect.
If you wish to replay the log file using perfmon you can set the data
source to be the file you have created and then it will show the
information in the perfmon window. The actual interpretation of the
results it up to you.
HTH
John
Frank wrote:
> Hi John,
> Thanks for your reply, but I still don't know how to read it.
> B/R
> Frank
> "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> news:D683CA66-7D14-4A3B-98D0-4DF2B6590D00@.microsoft.com...
> > Hi
> >
> > In the properties page the is a data source setting where you can
specify
> > current, log file or database
> >
> > John
> >
> > "Frank" wrote:
> >
> > > Hi,
> > >
> > > I would like to get these saved and later analysed, but could not
make
> it
> > > done, help please.
> > >
> > > Thanks in advance
> > > Frank
> > >
> > >
> > >

How to retrieve SqlDbType.Bit in SQL server?

Hi,

My checkbox status is saved as SqlDbType.Bit in MS SQl Server database.
When I use the following code to retrieve it, it does not work.

myRow[myColumn].ToString()=="1"

I appreciate your kind assistance.

Thank you.Just use

myRow[myColumn] == true

how to retrieve a password saved by SQL server

Hi,

I am able to connect to a SQL server and have checked the "remember my password" box in the connection diaglog window. Unfortunately, I forget what the password is, and now have to use it elsewhere. How can I get it? (I tried copy and paste, but it won't work).

Thanks,

Hi,

Unfortunatly I am beginer in this but it happens for me to have a corrupted master database and I couldn't login to SQL. The solution it was that I restore the master database using the command: rebuildm.exe from the SQL CD.

If I would have a problem like you, I would make a screen shots of all the settings which I have, I will detache the database I will stop the SQL service and I will restore the master database and I will put a new password and redo all the settings.

Good luck,

Diana

|||

Diana, thanks a lot for reply. I am still hoping there might a way to extract the password from my computer (since i have no trouble connecting to the server). Does anybody have any idea?

Thanks,

June

|||MSSQL stores not passwords but password hashes. There is no way to retrieve clear password from its hash: the hash operation is irreversible.