Can I get Total CPU usage or Memory use by TSQL

Hi
I dont have direct access to Server Terminal.
Can I get Server CPU Utilization and total memory use and memory use
by sql server using TSQL?
Regards
Amish Shah
Hi
It is not clear what you are looking for hear. You may want to look at the
set options:
SET SET STATISTICS IO ON
SET SET STATISTICS TIME ON
or look at SQL Profiler.
John
"amish" wrote:

> Hi
> I dont have direct access to Server Terminal.
> Can I get Server CPU Utilization and total memory use and memory use
> by sql server using TSQL?
> Regards
> Amish Shah
>
|||Actually I want to know total cpu utilization and memory utilization of
server and how much sql server consuming in this both. I can connect to
the server only by sql server. I dont have windows user/password.
So, is there any way i can get this information by tsql?
Thanks
AM
*** Sent via Developersdex http://www.codecomments.com ***
|||Hi
You may want to look at @.@.CPU_BUSY, @.@.IDLE, @.@.TIMETICKS or sp_monitor
You may also want to check out DBCC RESOURCE at
http://www.transactsql.com/html/DBCC%20RESOURCE.html
and other dbcc commands such as DBCC PERFMON, DBCC PROCCACHE, DBCC BUFFER
although I am not sure where to find total memory used.
Also look at sp_configure to find out the maximum configured value.
John
"AM" wrote:

> Actually I want to know total cpu utilization and memory utilization of
> server and how much sql server consuming in this both. I can connect to
> the server only by sql server. I dont have windows user/password.
> So, is there any way i can get this information by tsql?
> Thanks
> AM
> *** Sent via Developersdex http://www.codecomments.com ***
>
|||Some times CPU Utilization of my server goes upto 80% to 100 %. I want
to get this detail using TSQL.
I also want to know how much % sql server taking of over all cpu
utilization.
I want to do all this using SQL Server.
Thanks
AM
*** Sent via Developersdex http://www.codecomments.com ***
|||Hi
This is really the job of performance monitor, and this will give you a
pro-active method of monitoring it. I suggest you get the system admin to set
these up. If you are using MOM or similar you can do it that way.
John
"AM" wrote:

> Some times CPU Utilization of my server goes upto 80% to 100 %. I want
> to get this detail using TSQL.
> I also want to know how much % sql server taking of over all cpu
> utilization.
> I want to do all this using SQL Server.
>
> Thanks
> AM
> *** Sent via Developersdex http://www.codecomments.com ***
>

Can I get Total CPU usage or Memory use by TSQL

Hi
I dont have direct access to Server Terminal.
Can I get Server CPU Utilization and total memory use and memory use
by sql server using TSQL?
Regards
Amish ShahHi
It is not clear what you are looking for hear. You may want to look at the
set options:
SET SET STATISTICS IO ON
SET SET STATISTICS TIME ON
or look at SQL Profiler.
John
"amish" wrote:
> Hi
> I dont have direct access to Server Terminal.
> Can I get Server CPU Utilization and total memory use and memory use
> by sql server using TSQL?
> Regards
> Amish Shah
>|||Hi
You may want to look at @.@.CPU_BUSY, @.@.IDLE, @.@.TIMETICKS or sp_monitor
You may also want to check out DBCC RESOURCE at
http://www.transactsql.com/html/DBCC%20RESOURCE.html
and other dbcc commands such as DBCC PERFMON, DBCC PROCCACHE, DBCC BUFFER
although I am not sure where to find total memory used.
Also look at sp_configure to find out the maximum configured value.
John
"AM" wrote:
> Actually I want to know total cpu utilization and memory utilization of
> server and how much sql server consuming in this both. I can connect to
> the server only by sql server. I dont have windows user/password.
> So, is there any way i can get this information by tsql?
> Thanks
> AM
> *** Sent via Developersdex http://www.developersdex.com ***
>|||Hi
This is really the job of performance monitor, and this will give you a
pro-active method of monitoring it. I suggest you get the system admin to set
these up. If you are using MOM or similar you can do it that way.
John
"AM" wrote:
> Some times CPU Utilization of my server goes upto 80% to 100 %. I want
> to get this detail using TSQL.
> I also want to know how much % sql server taking of over all cpu
> utilization.
> I want to do all this using SQL Server.
>
> Thanks
> AM
> *** Sent via Developersdex http://www.developersdex.com ***
>

Can I get Total CPU usage or Memory use by TSQL

Hi
I dont have direct access to Server Terminal.
Can I get Server CPU Utilization and total memory use and memory use
by sql server using TSQL?
Regards
Amish ShahHi
It is not clear what you are looking for hear. You may want to look at the
set options:
SET SET STATISTICS IO ON
SET SET STATISTICS TIME ON
or look at SQL Profiler.
John
"amish" wrote:

> Hi
> I dont have direct access to Server Terminal.
> Can I get Server CPU Utilization and total memory use and memory use
> by sql server using TSQL?
> Regards
> Amish Shah
>|||Actually I want to know total cpu utilization and memory utilization of
server and how much sql server consuming in this both. I can connect to
the server only by sql server. I dont have windows user/password.
So, is there any way i can get this information by tsql?
Thanks
AM
*** Sent via Developersdex http://www.codecomments.com ***|||Hi
You may want to look at @.@.CPU_BUSY, @.@.IDLE, @.@.TIMETICKS or sp_monitor
You may also want to check out DBCC RESOURCE at
http://www.transactsql.com/html/DBCC%20RESOURCE.html
and other dbcc commands such as DBCC PERFMON, DBCC PROCCACHE, DBCC BUFFER
although I am not sure where to find total memory used.
Also look at sp_configure to find out the maximum configured value.
John
"AM" wrote:

> Actually I want to know total cpu utilization and memory utilization of
> server and how much sql server consuming in this both. I can connect to
> the server only by sql server. I dont have windows user/password.
> So, is there any way i can get this information by tsql?
> Thanks
> AM
> *** Sent via Developersdex http://www.codecomments.com ***
>|||Some times CPU Utilization of my server goes upto 80% to 100 %. I want
to get this detail using TSQL.
I also want to know how much % sql server taking of over all cpu
utilization.
I want to do all this using SQL Server.
Thanks
AM
*** Sent via Developersdex http://www.codecomments.com ***|||Hi
This is really the job of performance monitor, and this will give you a
pro-active method of monitoring it. I suggest you get the system admin to se
t
these up. If you are using MOM or similar you can do it that way.
John
"AM" wrote:

> Some times CPU Utilization of my server goes upto 80% to 100 %. I want
> to get this detail using TSQL.
> I also want to know how much % sql server taking of over all cpu
> utilization.
> I want to do all this using SQL Server.
>
> Thanks
> AM
> *** Sent via Developersdex http://www.codecomments.com ***
>sql

Can create login but cannot connect (sa doesn't even work also)

Hi,

Please direct me to the right forum if this is not the right one.

Upon installation of SQL Server 2005, I opened the SQL Server Management Studio, connected using Windows Authentication and went to the security node in the tree. I created a log in called "TestLogin". I restarted my server just to make sure everything took and when I tried to log in using TestLogin via SQL Server Authentication, I get the below error. I have mixed mode enabled as well as named pipes. I am not sure what the issue is or what to try next. I even get the same error when trying to use "sa".

Thanks,

- Joel

TITLE: Connect to Server

Cannot connect to TestServer.

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

BUTTONS:

OK

Can you check the SQL Server errorlog and copy the last errors reported there?

Thanks
Laurentiu

|||Hi. I had the same problem. Username is case sensitiv and the error message is odd...

Can create login but cannot connect (sa doesn't even work also)

Hi,

Please direct me to the right forum if this is not the right one.

Upon installation of SQL Server 2005, I opened the SQL Server Management Studio, connected using Windows Authentication and went to the security node in the tree. I created a log in called "TestLogin". I restarted my server just to make sure everything took and when I tried to log in using TestLogin via SQL Server Authentication, I get the below error. I have mixed mode enabled as well as named pipes. I am not sure what the issue is or what to try next. I even get the same error when trying to use "sa".

Thanks,

- Joel

TITLE: Connect to Server

Cannot connect to TestServer.

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

BUTTONS:

OK

Can you check the SQL Server errorlog and copy the last errors reported there?

Thanks
Laurentiu

|||Hi. I had the same problem. Username is case sensitiv and the error message is odd...