How to force usage on NTLM

Hi,
By default Windows authentication will use Kerberos to do the
authentication. Is there a way to force a SQL Server instance to use
NTLM rather than Kerberos - as a server setting?
Thanks,
-RonHi Ron,
No unfortunately, there isn't . I have filed a "Design Change Request"
on this though.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I found this question interesting and wanted to know the pros and cons of
one method over another
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:91hgbFXMFHA.560@.TK2MSFTNGXA03.phx.gbl...
> Hi Ron,
> No unfortunately, there isn't . I have filed a "Design Change Request"
> on this though.
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||Hi Kevin,
Thanks for the reply - and the change request is a good thing to look
forward to.
In the interim, I'm wondering whether you can shed some light on what
would be needed to build a "quick-and-dirty" workaround. What I'm
trying to understand is what the fall-back looks like. For example,
what does SQLServer look for in determining whether or not it has
access to kerberos authentication? Does it send something ove rthe
network? If I were to stop it using a firewall on a certain port would
I eventually get it to use NTLM? Any reference to what actually goes on
under the covers in Kerberos authentication that can help me work
something out?
Thanks for the help,
-Ron|||Well, one thing you could try is to force the connection to use Named
Pipes. I believe the last time I tested this, Named Pipes would always
authenticate via NTLM. Whereas with TCP to make a Trusted Connection we
rely on SSPI and always try Kerberos first. Named Pipes can impersonate
the client natively, and don't need to go thru the SSPI api. Essentially,
there should be less overhead with Trusted Connections using Pipes that
Sockets in this regard.
Hope this helps,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks again Kevin - great idea - I'll try that.
One more question if you don't mind. I inderstand (kind of) the use of
the Windows services for the authentication and authorization piece.
However, I noticed that even when this is used the sysprocesses table
always has teh right information - e.g. PROGRAM_NAME. That means that
eventually the information is being decrypted by SQL Server itself from
the TCP/IP handshake. Is this true or is this also a service provided
by SSPI? Is there anywhere to read up on this - the more I think I
understand the mechanism the less I really do.
Thanks,
-Ron|||The Program Name is being passed from the connection parameters I believe.
Example:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;User ID=;Initial Catalog=Idea;Data Source=TestSQL;Application
Name=My Application Name Here
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

How to find out CPU saturation in T-SQL

Hello,
I was wondering if there is a way to find out in T-SQL how busy CPU is. I
would like to get the same information as shown in CPU usage graph in Task
Manager.
Thanks,
IgorThere are other processes other than SQL Server that consume CPU resources.
Perhaps you can get this information using WMI.
"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:elq%23aIoKFHA.3960@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I was wondering if there is a way to find out in T-SQL how busy CPU is. I
> would like to get the same information as shown in CPU usage graph in Task
> Manager.
> Thanks,
> Igor
>|||I was hoping to obtain this information using T-SQL.
<WKidd> wrote in message news:%23ImbyToKFHA.1284@.TK2MSFTNGP14.phx.gbl...
> There are other processes other than SQL Server that consume CPU
> resources. Perhaps you can get this information using WMI.
> "Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
> news:elq%23aIoKFHA.3960@.TK2MSFTNGP09.phx.gbl...
>|||Igor Marchenko wrote:
> Hello,
> I was wondering if there is a way to find out in T-SQL how busy CPU
> is. I would like to get the same information as shown in CPU usage
> graph in Task Manager.
> Thanks,
> Igor
Not for the entire server. Only for SQL Server.
David Gugick
Imceda Software
www.imceda.com|||Could you please tell me how to do it for SQL server? I would like to know
how much of CPU percent wise is used by SQL server. Similar to what is shown
in process tab of Task bar.
Thanks,
Igor
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OJfqq4pKFHA.3552@.TK2MSFTNGP12.phx.gbl...
> Igor Marchenko wrote:
> Not for the entire server. Only for SQL Server.
> --
> David Gugick
> Imceda Software
> www.imceda.com|||You can use perfmon to see how much cpu SQL server is using, and it auto
refreshes so you watch and record performance.
Under "Process" performance object, select "% Processor Time", and in the
"Select instance from a list" section, select "sqlservr".
Obviously this is not a t-sql solution, but probably more intuitive,
especially if you want to log the results to review later.
Simon Worth
"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:uvuFOvxKFHA.440@.TK2MSFTNGP10.phx.gbl...
> Could you please tell me how to do it for SQL server? I would like to know
> how much of CPU percent wise is used by SQL server. Similar to what is
shown
> in process tab of Task bar.
> Thanks,
> Igor
> "David Gugick" <davidg-nospam@.imceda.com> wrote in message
> news:OJfqq4pKFHA.3552@.TK2MSFTNGP12.phx.gbl...
>|||Igor Marchenko wrote:
> Could you please tell me how to do it for SQL server? I would like to
> know how much of CPU percent wise is used by SQL server. Similar to
> what is shown in process tab of Task bar.
> Thanks,
> Igor
From T-SQL, you can use the @.@.CPU_BUSY global variable along with
@.@.TIMETICKS. You'll have to search Google for the required calculation
as you'll have to compare the toal cpu used over an interval as compared
to the total time.
David Gugick
Imceda Software
www.imceda.com

How to find out CPU saturation in SQL server

Hello,
I was wondering if there is a way to find out in T-SQL how busy CPU is. I
would like to get the same information as shown in CPU usage graph in Task
Manager.
Thanks,
Igor
Performance Monitor ?
Gopi
"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:%23d21PIoKFHA.2936@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I was wondering if there is a way to find out in T-SQL how busy CPU is. I
> would like to get the same information as shown in CPU usage graph in Task
> Manager.
> Thanks,
> Igor
>
|||I would like to ontain this information programmatically ideally using
T-SQL.
Thanks,
Igor
"rgn" <gopinathr@.healthasyst.com> wrote in message
news:%23y8EvkvKFHA.3960@.TK2MSFTNGP09.phx.gbl...
> Performance Monitor ?
> Gopi
> "Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
> news:%23d21PIoKFHA.2936@.TK2MSFTNGP15.phx.gbl...
>

How to find out CPU saturation in SQL server

Hello,
I was wondering if there is a way to find out in T-SQL how busy CPU is. I
would like to get the same information as shown in CPU usage graph in Task
Manager.
Thanks,
IgorPerformance Monitor ?
Gopi
"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:%23d21PIoKFHA.2936@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I was wondering if there is a way to find out in T-SQL how busy CPU is. I
> would like to get the same information as shown in CPU usage graph in Task
> Manager.
> Thanks,
> Igor
>|||I would like to ontain this information programmatically ideally using
T-SQL.
Thanks,
Igor
"rgn" <gopinathr@.healthasyst.com> wrote in message
news:%23y8EvkvKFHA.3960@.TK2MSFTNGP09.phx.gbl...
> Performance Monitor ?
> Gopi
> "Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
> news:%23d21PIoKFHA.2936@.TK2MSFTNGP15.phx.gbl...
>

How to find out CPU saturation in SQL server

Hello,
I was wondering if there is a way to find out in T-SQL how busy CPU is. I
would like to get the same information as shown in CPU usage graph in Task
Manager.
Thanks,
IgorPerformance Monitor ?
Gopi
"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:%23d21PIoKFHA.2936@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I was wondering if there is a way to find out in T-SQL how busy CPU is. I
> would like to get the same information as shown in CPU usage graph in Task
> Manager.
> Thanks,
> Igor
>|||I would like to ontain this information programmatically ideally using
T-SQL.
Thanks,
Igor
"rgn" <gopinathr@.healthasyst.com> wrote in message
news:%23y8EvkvKFHA.3960@.TK2MSFTNGP09.phx.gbl...
> Performance Monitor ?
> Gopi
> "Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
> news:%23d21PIoKFHA.2936@.TK2MSFTNGP15.phx.gbl...
>> Hello,
>> I was wondering if there is a way to find out in T-SQL how busy CPU is. I
>> would like to get the same information as shown in CPU usage graph in
>> Task Manager.
>> Thanks,
>> Igor
>

How to Find Index Size / Usage (mb)

I'm trying to establish the mb usage of a series of nonclustered indexes, I'm used to using the manage indexes GUI in 6.5, and showcontig doesn't quite give me what I want, any suggestions?Have you tried sp_spaceused <table_name> yet?|||That's a great help thanks, is it possible to drill down into the 3 indexes to see how the usage is split?

How to find current memory usage using SQL?

Anybody knows of any DBCC command or sp_configure param
which would tell me how much memory is SQL Server
currently grabbing?
I don't want to use DBCC perfmon(lrustats) because (1) it
is being deprecated and (b) the output is voluminous.
Using performance monitors is not an option since I want
to be able to do this from within a SQL script.
Thx a bunch!Check out master..sysperfinfo. The values in this table are not completely
cooked. Check out msdb..sp_sqlagent_get_perf_counters to see how the counter
values can be cooked.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Asim" <aabubba@.yahoo.com> wrote in message
news:1fc7001c38a3b$4f2fc4a0$a601280a@.phx.gbl...
> Anybody knows of any DBCC command or sp_configure param
> which would tell me how much memory is SQL Server
> currently grabbing?
> I don't want to use DBCC perfmon(lrustats) because (1) it
> is being deprecated and (b) the output is voluminous.
> Using performance monitors is not an option since I want
> to be able to do this from within a SQL script.
> Thx a bunch!