Hello,
I have one database server with 4 CPU's. Normally the server has no problems
and the server has a lot of free CPU and memory for SQL Server. Since
yesterday the CPU's are completely crazys and in all of them have the
%processor time rises above 80%
In taskmgr i see sqlsrvr.exe w/ CPU utilization between 60 and 80 percent.
Have u any ideas to start trobleshooting this problem? Is it possible that
the cause of this problem its being produced by code executed(any stored
proc, etc, etc...)
Hope that you can help me.
Thanks and best regards
Go onto your server and have a look at 'Task Manager' to see which process is
causing the most CPU time.
We had a similar issue with backups. It seemed to clear itself after about a
day.
Peter
"All generalizations are false, including this one."
Mark Twain
"CC&JM" wrote:
> Hello,
> I have one database server with 4 CPU's. Normally the server has no problems
> and the server has a lot of free CPU and memory for SQL Server. Since
> yesterday the CPU's are completely crazys and in all of them have the
> %processor time rises above 80%
> In taskmgr i see sqlsrvr.exe w/ CPU utilization between 60 and 80 percent.
> Have u any ideas to start trobleshooting this problem? Is it possible that
> the cause of this problem its being produced by code executed(any stored
> proc, etc, etc...)
> Hope that you can help me.
> Thanks and best regards
>
Showing posts with label normally. Show all posts
Showing posts with label normally. Show all posts
Monday, March 19, 2012
High CPU Utilization
Hello,
I have one database server with 4 CPU's. Normally the server has no problems
and the server has a lot of free CPU and memory for SQL Server. Since
yesterday the CPU's are completely crazys and in all of them have the
%processor time rises above 80%
In taskmgr i see sqlsrvr.exe w/ CPU utilization between 60 and 80 percent.
Have u any ideas to start trobleshooting this problem? Is it possible that
the cause of this problem its being produced by code executed(any stored
proc, etc, etc...)
Hope that you can help me.
Thanks and best regardsGo onto your server and have a look at 'Task Manager' to see which process i
s
causing the most CPU time.
We had a similar issue with backups. It seemed to clear itself after about a
day.
Peter
"All generalizations are false, including this one."
Mark Twain
"CC&JM" wrote:
> Hello,
> I have one database server with 4 CPU's. Normally the server has no proble
ms
> and the server has a lot of free CPU and memory for SQL Server. Since
> yesterday the CPU's are completely crazys and in all of them have the
> %processor time rises above 80%
> In taskmgr i see sqlsrvr.exe w/ CPU utilization between 60 and 80 percent.
> Have u any ideas to start trobleshooting this problem? Is it possible that
> the cause of this problem its being produced by code executed(any stored
> proc, etc, etc...)
> Hope that you can help me.
> Thanks and best regards
>
I have one database server with 4 CPU's. Normally the server has no problems
and the server has a lot of free CPU and memory for SQL Server. Since
yesterday the CPU's are completely crazys and in all of them have the
%processor time rises above 80%
In taskmgr i see sqlsrvr.exe w/ CPU utilization between 60 and 80 percent.
Have u any ideas to start trobleshooting this problem? Is it possible that
the cause of this problem its being produced by code executed(any stored
proc, etc, etc...)
Hope that you can help me.
Thanks and best regardsGo onto your server and have a look at 'Task Manager' to see which process i
s
causing the most CPU time.
We had a similar issue with backups. It seemed to clear itself after about a
day.
Peter
"All generalizations are false, including this one."
Mark Twain
"CC&JM" wrote:
> Hello,
> I have one database server with 4 CPU's. Normally the server has no proble
ms
> and the server has a lot of free CPU and memory for SQL Server. Since
> yesterday the CPU's are completely crazys and in all of them have the
> %processor time rises above 80%
> In taskmgr i see sqlsrvr.exe w/ CPU utilization between 60 and 80 percent.
> Have u any ideas to start trobleshooting this problem? Is it possible that
> the cause of this problem its being produced by code executed(any stored
> proc, etc, etc...)
> Hope that you can help me.
> Thanks and best regards
>
High CPU Utilization
Hello,
I have one database server with 4 CPU's. Normally the server has no problems
and the server has a lot of free CPU and memory for SQL Server. Since
yesterday the CPU's are completely crazys and in all of them have the
%processor time rises above 80%
In taskmgr i see sqlsrvr.exe w/ CPU utilization between 60 and 80 percent.
Have u any ideas to start trobleshooting this problem? Is it possible that
the cause of this problem its being produced by code executed(any stored
proc, etc, etc...)
Hope that you can help me.
Thanks and best regardsGo onto your server and have a look at 'Task Manager' to see which process is
causing the most CPU time.
We had a similar issue with backups. It seemed to clear itself after about a
day.
Peter
"All generalizations are false, including this one."
Mark Twain
"CC&JM" wrote:
> Hello,
> I have one database server with 4 CPU's. Normally the server has no problems
> and the server has a lot of free CPU and memory for SQL Server. Since
> yesterday the CPU's are completely crazys and in all of them have the
> %processor time rises above 80%
> In taskmgr i see sqlsrvr.exe w/ CPU utilization between 60 and 80 percent.
> Have u any ideas to start trobleshooting this problem? Is it possible that
> the cause of this problem its being produced by code executed(any stored
> proc, etc, etc...)
> Hope that you can help me.
> Thanks and best regards
>
I have one database server with 4 CPU's. Normally the server has no problems
and the server has a lot of free CPU and memory for SQL Server. Since
yesterday the CPU's are completely crazys and in all of them have the
%processor time rises above 80%
In taskmgr i see sqlsrvr.exe w/ CPU utilization between 60 and 80 percent.
Have u any ideas to start trobleshooting this problem? Is it possible that
the cause of this problem its being produced by code executed(any stored
proc, etc, etc...)
Hope that you can help me.
Thanks and best regardsGo onto your server and have a look at 'Task Manager' to see which process is
causing the most CPU time.
We had a similar issue with backups. It seemed to clear itself after about a
day.
Peter
"All generalizations are false, including this one."
Mark Twain
"CC&JM" wrote:
> Hello,
> I have one database server with 4 CPU's. Normally the server has no problems
> and the server has a lot of free CPU and memory for SQL Server. Since
> yesterday the CPU's are completely crazys and in all of them have the
> %processor time rises above 80%
> In taskmgr i see sqlsrvr.exe w/ CPU utilization between 60 and 80 percent.
> Have u any ideas to start trobleshooting this problem? Is it possible that
> the cause of this problem its being produced by code executed(any stored
> proc, etc, etc...)
> Hope that you can help me.
> Thanks and best regards
>
Monday, March 12, 2012
High CPU Usage
Hello,
I need your help urgently.
I have a MsSQL server database that behaves normally all day, but at certain
times the server's cpu usage rises abnormally.
There's no increase in the amount of transactions sent to the server,
there's no scheduled job running, and apparently there's no other
application running on the server.
Could you tell me the tools availble to identify what's the cause of the
high CPU usage? with Perfomance monitor I get the %Processor Time but I
don't get the source of the problem.
Any ideas,
TIA
Eduardo Sicouret
You can go into task manager and select the "Processes" tab. Once there
click the CPU column to sort it... this should show you which
process/application is using the CPU the most.
HTH
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> Hello,
> I need your help urgently.
> I have a MsSQL server database that behaves normally all day, but at certain
> times the server's cpu usage rises abnormally.
> There's no increase in the amount of transactions sent to the server,
> there's no scheduled job running, and apparently there's no other
> application running on the server.
> Could you tell me the tools availble to identify what's the cause of the
> high CPU usage? with Perfomance monitor I get the %Processor Time but I
> don't get the source of the problem.
> Any ideas,
> TIA
> Eduardo Sicouret
>
>
|||I get that SQL server is the process that's taking the most CPU time... but
I don't know what is it doing
Eduardo
"Adam Warne" <AdamWarne@.discussions.microsoft.com> escribi en el mensaje
news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...[vbcol=seagreen]
> You can go into task manager and select the "Processes" tab. Once there
> click the CPU column to sort it... this should show you which
> process/application is using the CPU the most.
> HTH
> --
> Adam J Warne, MCDBA
>
> "Eduardo Sicouret" wrote:
|||My apologies Eduardo, I misread the question ... one of those days.
In this instance, you could run a trace through SQL profiler to see what
transactions are running when the CPU usage peaks.
Alternatively, you can execute "sp_who2" and this will show you the spids
that have a high CPU time. You can then run "dbcc inputbuffer (spid)" to see
what command is being executed for that spid.
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> I get that SQL server is the process that's taking the most CPU time... but
> I don't know what is it doing
> Eduardo
> "Adam Warne" <AdamWarne@.discussions.microsoft.com> escribió en el mensaje
> news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...
>
>
I need your help urgently.
I have a MsSQL server database that behaves normally all day, but at certain
times the server's cpu usage rises abnormally.
There's no increase in the amount of transactions sent to the server,
there's no scheduled job running, and apparently there's no other
application running on the server.
Could you tell me the tools availble to identify what's the cause of the
high CPU usage? with Perfomance monitor I get the %Processor Time but I
don't get the source of the problem.
Any ideas,
TIA
Eduardo Sicouret
You can go into task manager and select the "Processes" tab. Once there
click the CPU column to sort it... this should show you which
process/application is using the CPU the most.
HTH
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> Hello,
> I need your help urgently.
> I have a MsSQL server database that behaves normally all day, but at certain
> times the server's cpu usage rises abnormally.
> There's no increase in the amount of transactions sent to the server,
> there's no scheduled job running, and apparently there's no other
> application running on the server.
> Could you tell me the tools availble to identify what's the cause of the
> high CPU usage? with Perfomance monitor I get the %Processor Time but I
> don't get the source of the problem.
> Any ideas,
> TIA
> Eduardo Sicouret
>
>
|||I get that SQL server is the process that's taking the most CPU time... but
I don't know what is it doing
Eduardo
"Adam Warne" <AdamWarne@.discussions.microsoft.com> escribi en el mensaje
news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...[vbcol=seagreen]
> You can go into task manager and select the "Processes" tab. Once there
> click the CPU column to sort it... this should show you which
> process/application is using the CPU the most.
> HTH
> --
> Adam J Warne, MCDBA
>
> "Eduardo Sicouret" wrote:
|||My apologies Eduardo, I misread the question ... one of those days.
In this instance, you could run a trace through SQL profiler to see what
transactions are running when the CPU usage peaks.
Alternatively, you can execute "sp_who2" and this will show you the spids
that have a high CPU time. You can then run "dbcc inputbuffer (spid)" to see
what command is being executed for that spid.
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> I get that SQL server is the process that's taking the most CPU time... but
> I don't know what is it doing
> Eduardo
> "Adam Warne" <AdamWarne@.discussions.microsoft.com> escribió en el mensaje
> news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...
>
>
High CPU Usage
Hello,
I need your help urgently.
I have a MsSQL server database that behaves normally all day, but at certain
times the server's cpu usage rises abnormally.
There's no increase in the amount of transactions sent to the server,
there's no scheduled job running, and apparently there's no other
application running on the server.
Could you tell me the tools availble to identify what's the cause of the
high CPU usage? with Perfomance monitor I get the %Processor Time but I
don't get the source of the problem.
Any ideas,
TIA
Eduardo SicouretYou can go into task manager and select the "Processes" tab. Once there
click the CPU column to sort it... this should show you which
process/application is using the CPU the most.
HTH
--
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> Hello,
> I need your help urgently.
> I have a MsSQL server database that behaves normally all day, but at certa
in
> times the server's cpu usage rises abnormally.
> There's no increase in the amount of transactions sent to the server,
> there's no scheduled job running, and apparently there's no other
> application running on the server.
> Could you tell me the tools availble to identify what's the cause of the
> high CPU usage? with Perfomance monitor I get the %Processor Time but I
> don't get the source of the problem.
> Any ideas,
> TIA
> Eduardo Sicouret
>
>|||I get that SQL server is the process that's taking the most CPU time... but
I don't know what is it doing
Eduardo
"Adam Warne" <AdamWarne@.discussions.microsoft.com> escribi en el mensaje
news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...[vbcol=seagreen]
> You can go into task manager and select the "Processes" tab. Once there
> click the CPU column to sort it... this should show you which
> process/application is using the CPU the most.
> HTH
> --
> Adam J Warne, MCDBA
>
> "Eduardo Sicouret" wrote:
>|||My apologies Eduardo, I misread the question ... one of those days.
In this instance, you could run a trace through SQL profiler to see what
transactions are running when the CPU usage peaks.
Alternatively, you can execute "sp_who2" and this will show you the spids
that have a high CPU time. You can then run "dbcc inputbuffer (spid)" to se
e
what command is being executed for that spid.
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> I get that SQL server is the process that's taking the most CPU time... b
ut
> I don't know what is it doing
> Eduardo
> "Adam Warne" <AdamWarne@.discussions.microsoft.com> escribió en el mensaje
> news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...
>
>
I need your help urgently.
I have a MsSQL server database that behaves normally all day, but at certain
times the server's cpu usage rises abnormally.
There's no increase in the amount of transactions sent to the server,
there's no scheduled job running, and apparently there's no other
application running on the server.
Could you tell me the tools availble to identify what's the cause of the
high CPU usage? with Perfomance monitor I get the %Processor Time but I
don't get the source of the problem.
Any ideas,
TIA
Eduardo SicouretYou can go into task manager and select the "Processes" tab. Once there
click the CPU column to sort it... this should show you which
process/application is using the CPU the most.
HTH
--
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> Hello,
> I need your help urgently.
> I have a MsSQL server database that behaves normally all day, but at certa
in
> times the server's cpu usage rises abnormally.
> There's no increase in the amount of transactions sent to the server,
> there's no scheduled job running, and apparently there's no other
> application running on the server.
> Could you tell me the tools availble to identify what's the cause of the
> high CPU usage? with Perfomance monitor I get the %Processor Time but I
> don't get the source of the problem.
> Any ideas,
> TIA
> Eduardo Sicouret
>
>|||I get that SQL server is the process that's taking the most CPU time... but
I don't know what is it doing
Eduardo
"Adam Warne" <AdamWarne@.discussions.microsoft.com> escribi en el mensaje
news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...[vbcol=seagreen]
> You can go into task manager and select the "Processes" tab. Once there
> click the CPU column to sort it... this should show you which
> process/application is using the CPU the most.
> HTH
> --
> Adam J Warne, MCDBA
>
> "Eduardo Sicouret" wrote:
>|||My apologies Eduardo, I misread the question ... one of those days.
In this instance, you could run a trace through SQL profiler to see what
transactions are running when the CPU usage peaks.
Alternatively, you can execute "sp_who2" and this will show you the spids
that have a high CPU time. You can then run "dbcc inputbuffer (spid)" to se
e
what command is being executed for that spid.
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> I get that SQL server is the process that's taking the most CPU time... b
ut
> I don't know what is it doing
> Eduardo
> "Adam Warne" <AdamWarne@.discussions.microsoft.com> escribió en el mensaje
> news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...
>
>
High CPU Usage
Hello,
I need your help urgently.
I have a MsSQL server database that behaves normally all day, but at certain
times the server's cpu usage rises abnormally.
There's no increase in the amount of transactions sent to the server,
there's no scheduled job running, and apparently there's no other
application running on the server.
Could you tell me the tools availble to identify what's the cause of the
high CPU usage? with Perfomance monitor I get the %Processor Time but I
don't get the source of the problem.
Any ideas,
TIA
Eduardo SicouretYou can go into task manager and select the "Processes" tab. Once there
click the CPU column to sort it... this should show you which
process/application is using the CPU the most.
HTH
--
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> Hello,
> I need your help urgently.
> I have a MsSQL server database that behaves normally all day, but at certain
> times the server's cpu usage rises abnormally.
> There's no increase in the amount of transactions sent to the server,
> there's no scheduled job running, and apparently there's no other
> application running on the server.
> Could you tell me the tools availble to identify what's the cause of the
> high CPU usage? with Perfomance monitor I get the %Processor Time but I
> don't get the source of the problem.
> Any ideas,
> TIA
> Eduardo Sicouret
>
>|||I get that SQL server is the process that's taking the most CPU time... but
I don't know what is it doing
Eduardo
"Adam Warne" <AdamWarne@.discussions.microsoft.com> escribió en el mensaje
news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...
> You can go into task manager and select the "Processes" tab. Once there
> click the CPU column to sort it... this should show you which
> process/application is using the CPU the most.
> HTH
> --
> Adam J Warne, MCDBA
>
> "Eduardo Sicouret" wrote:
>> Hello,
>> I need your help urgently.
>> I have a MsSQL server database that behaves normally all day, but at
>> certain
>> times the server's cpu usage rises abnormally.
>> There's no increase in the amount of transactions sent to the server,
>> there's no scheduled job running, and apparently there's no other
>> application running on the server.
>> Could you tell me the tools availble to identify what's the cause of the
>> high CPU usage? with Perfomance monitor I get the %Processor Time but
>> I
>> don't get the source of the problem.
>> Any ideas,
>> TIA
>> Eduardo Sicouret
>>|||My apologies Eduardo, I misread the question ... one of those days.
In this instance, you could run a trace through SQL profiler to see what
transactions are running when the CPU usage peaks.
Alternatively, you can execute "sp_who2" and this will show you the spids
that have a high CPU time. You can then run "dbcc inputbuffer (spid)" to see
what command is being executed for that spid.
--
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> I get that SQL server is the process that's taking the most CPU time... but
> I don't know what is it doing
> Eduardo
> "Adam Warne" <AdamWarne@.discussions.microsoft.com> escribió en el mensaje
> news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...
> > You can go into task manager and select the "Processes" tab. Once there
> > click the CPU column to sort it... this should show you which
> > process/application is using the CPU the most.
> >
> > HTH
> > --
> > Adam J Warne, MCDBA
> >
> >
> > "Eduardo Sicouret" wrote:
> >
> >> Hello,
> >>
> >> I need your help urgently.
> >>
> >> I have a MsSQL server database that behaves normally all day, but at
> >> certain
> >> times the server's cpu usage rises abnormally.
> >>
> >> There's no increase in the amount of transactions sent to the server,
> >> there's no scheduled job running, and apparently there's no other
> >> application running on the server.
> >>
> >> Could you tell me the tools availble to identify what's the cause of the
> >> high CPU usage? with Perfomance monitor I get the %Processor Time but
> >> I
> >> don't get the source of the problem.
> >>
> >> Any ideas,
> >>
> >> TIA
> >>
> >> Eduardo Sicouret
> >>
> >>
> >>
>
>
I need your help urgently.
I have a MsSQL server database that behaves normally all day, but at certain
times the server's cpu usage rises abnormally.
There's no increase in the amount of transactions sent to the server,
there's no scheduled job running, and apparently there's no other
application running on the server.
Could you tell me the tools availble to identify what's the cause of the
high CPU usage? with Perfomance monitor I get the %Processor Time but I
don't get the source of the problem.
Any ideas,
TIA
Eduardo SicouretYou can go into task manager and select the "Processes" tab. Once there
click the CPU column to sort it... this should show you which
process/application is using the CPU the most.
HTH
--
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> Hello,
> I need your help urgently.
> I have a MsSQL server database that behaves normally all day, but at certain
> times the server's cpu usage rises abnormally.
> There's no increase in the amount of transactions sent to the server,
> there's no scheduled job running, and apparently there's no other
> application running on the server.
> Could you tell me the tools availble to identify what's the cause of the
> high CPU usage? with Perfomance monitor I get the %Processor Time but I
> don't get the source of the problem.
> Any ideas,
> TIA
> Eduardo Sicouret
>
>|||I get that SQL server is the process that's taking the most CPU time... but
I don't know what is it doing
Eduardo
"Adam Warne" <AdamWarne@.discussions.microsoft.com> escribió en el mensaje
news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...
> You can go into task manager and select the "Processes" tab. Once there
> click the CPU column to sort it... this should show you which
> process/application is using the CPU the most.
> HTH
> --
> Adam J Warne, MCDBA
>
> "Eduardo Sicouret" wrote:
>> Hello,
>> I need your help urgently.
>> I have a MsSQL server database that behaves normally all day, but at
>> certain
>> times the server's cpu usage rises abnormally.
>> There's no increase in the amount of transactions sent to the server,
>> there's no scheduled job running, and apparently there's no other
>> application running on the server.
>> Could you tell me the tools availble to identify what's the cause of the
>> high CPU usage? with Perfomance monitor I get the %Processor Time but
>> I
>> don't get the source of the problem.
>> Any ideas,
>> TIA
>> Eduardo Sicouret
>>|||My apologies Eduardo, I misread the question ... one of those days.
In this instance, you could run a trace through SQL profiler to see what
transactions are running when the CPU usage peaks.
Alternatively, you can execute "sp_who2" and this will show you the spids
that have a high CPU time. You can then run "dbcc inputbuffer (spid)" to see
what command is being executed for that spid.
--
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> I get that SQL server is the process that's taking the most CPU time... but
> I don't know what is it doing
> Eduardo
> "Adam Warne" <AdamWarne@.discussions.microsoft.com> escribió en el mensaje
> news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...
> > You can go into task manager and select the "Processes" tab. Once there
> > click the CPU column to sort it... this should show you which
> > process/application is using the CPU the most.
> >
> > HTH
> > --
> > Adam J Warne, MCDBA
> >
> >
> > "Eduardo Sicouret" wrote:
> >
> >> Hello,
> >>
> >> I need your help urgently.
> >>
> >> I have a MsSQL server database that behaves normally all day, but at
> >> certain
> >> times the server's cpu usage rises abnormally.
> >>
> >> There's no increase in the amount of transactions sent to the server,
> >> there's no scheduled job running, and apparently there's no other
> >> application running on the server.
> >>
> >> Could you tell me the tools availble to identify what's the cause of the
> >> high CPU usage? with Perfomance monitor I get the %Processor Time but
> >> I
> >> don't get the source of the problem.
> >>
> >> Any ideas,
> >>
> >> TIA
> >>
> >> Eduardo Sicouret
> >>
> >>
> >>
>
>
High Availability with Log Shipping
I have implemented log shipping between 2 databases, the transaction log size normally between 10mb - 50mb every 15 minutes during normal working hours, but it grows to 9GB when we run database optimization job and that makes it hard and long to transfer and apply the transaction log on the other database. Does anybody encountered a situation like this and is there a way to minimize the size of the Trans log after the optimization job?
ThanxUse the shrink command: You can look it up. It allow for a backup of the log then it's shrunk to the specified size. Please look up on Book on line or ms sql server support. I suggest shrinking before the other processes.
BACKUP LOG wslogdb62 WITH TRUNCATE_ONLY
DBCC SHRINKFILE('wslogdb62_log.ldf', 1)
ThanxUse the shrink command: You can look it up. It allow for a backup of the log then it's shrunk to the specified size. Please look up on Book on line or ms sql server support. I suggest shrinking before the other processes.
BACKUP LOG wslogdb62 WITH TRUNCATE_ONLY
DBCC SHRINKFILE('wslogdb62_log.ldf', 1)
Sunday, February 26, 2012
Hiding the Title Output ?
is there a way to suppress the output of the title of each column ?
i.e.
if that query would normally return
Name | Age | Rank
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt
Can i get it to return just:
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prtwhere ru runing this script? in QA?|||yes you can
select name as ' ' ,age as ' ',rank as ' ' from table_name
Originally posted by ontheDB
is there a way to suppress the output of the title of each column ?
i.e.
if that query would normally return
Name | Age | Rank
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt
Can i get it to return just:
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt|||actually the proposed query will return this:
| | |
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt
this means that the heading will not be suppressed, but rather renamed to empty strings.
in order to suppress the headings uncheck Print Column Headers in Tools/Options/Results of your query analyzer.|||Originally posted by ms_sql_dba
actually the proposed query will return this:
| | |
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt
this means that the heading will not be suppressed, but rather renamed to empty strings.
in order to suppress the headings uncheck Print Column Headers in Tools/Options/Results of your query analyzer.
This question is related to the reply, is it possible to "uncheck Print Column Headers" with actually going to Tools>Options>Results? Is there is a script that would do that same? For example in Oracle you can say:
Set Headings off
Is this possible in Query Analyzer 2000?
i.e.
if that query would normally return
Name | Age | Rank
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt
Can i get it to return just:
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prtwhere ru runing this script? in QA?|||yes you can
select name as ' ' ,age as ' ',rank as ' ' from table_name
Originally posted by ontheDB
is there a way to suppress the output of the title of each column ?
i.e.
if that query would normally return
Name | Age | Rank
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt
Can i get it to return just:
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt|||actually the proposed query will return this:
| | |
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt
this means that the heading will not be suppressed, but rather renamed to empty strings.
in order to suppress the headings uncheck Print Column Headers in Tools/Options/Results of your query analyzer.|||Originally posted by ms_sql_dba
actually the proposed query will return this:
| | |
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt
this means that the heading will not be suppressed, but rather renamed to empty strings.
in order to suppress the headings uncheck Print Column Headers in Tools/Options/Results of your query analyzer.
This question is related to the reply, is it possible to "uncheck Print Column Headers" with actually going to Tools>Options>Results? Is there is a script that would do that same? For example in Oracle you can say:
Set Headings off
Is this possible in Query Analyzer 2000?
Subscribe to:
Comments (Atom)