Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2011-02-09 : 22:19:21
|
| Trying to execute the the TYPEPERF to obtain the performance parameters with the help of this command:TYPEPERF -f SQL -s SQLDEV01 -cf “C:\Counterdirectory\Counter.txt” -si 15 -o SQL:SQLPERF!log1 -sc 4Explains:With server SQLDEV01; COUNTER.TXT as the Parameter initialized file; Duration 15 Seconds; using the DSN name as SQLPERF and LOG1 as Performance Data Collection Center and reapeated for 4 iterations This is complaining at LOG1 parameter.However, on executing got this error at the command prompt:'LOG1' is not recognized as an internal or external command, operable program or batch file.Tried all possible ways but couldn't find reason.Can anyone give me what should be replaced for the LOG1 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-02-10 : 04:34:15
|
| Well, according to the documentation the -o switch "Specifies the pathname of the output file. Defaults to stdout." Have you tried specifying a filename?- LumbagoMy blog-> www.thefirstsql.com |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-02-10 : 23:16:16
|
| its default to LOG1 in the document which is why is complaining.Thanks for it, still couldn't rectify. any further help. |
|
|
|
|
|
|
Performance with TYPEPERF