Default merge agent profile settings

I'd like to be able to either change the default profile settings or change
the default profile to a user defined profile.
So far I've only been able to change the profile after the merge agent is
created. I'd like to change the defaults for
any new merge agents that are created.
TIA
here is an example of updating the merge default profile's LoginTimeOut from
15s to 120s.
update msdb.dbo.MSagent_parameters set value=120 where
parameter_name='-LoginTimeout' and profile_id=6
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Darren" <deo.is@.unknown.com> wrote in message
news:%23$AjOiSGFHA.2568@.TK2MSFTNGP10.phx.gbl...
> I'd like to be able to either change the default profile settings or
change
> the default profile to a user defined profile.
> So far I've only been able to change the profile after the merge agent is
> created. I'd like to change the defaults for
> any new merge agents that are created.
> TIA
>
>
|||Or like this?
sp_change_agent_parameter @.profile_id = 6, @.parameter_name =
N'-UploadReadChangesPerBatch', @.parameter_value = N'2000'
Are the default profile IDs documented anywhere?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uIGGPvVGFHA.1068@.TK2MSFTNGP14.phx.gbl...
> here is an example of updating the merge default profile's LoginTimeOut
from[vbcol=seagreen]
> 15s to 120s.
>
> update msdb.dbo.MSagent_parameters set value=120 where
> parameter_name='-LoginTimeout' and profile_id=6
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Darren" <deo.is@.unknown.com> wrote in message
> news:%23$AjOiSGFHA.2568@.TK2MSFTNGP10.phx.gbl...
> change
is
>
|||Found it in BOL under sp_help_agent_profile
"Darren" <deo.is@.unknown.com> wrote in message
news:OkkNEVcGFHA.400@.TK2MSFTNGP14.phx.gbl...
> Or like this?
> sp_change_agent_parameter @.profile_id = 6, @.parameter_name =
> N'-UploadReadChangesPerBatch', @.parameter_value = N'2000'
> Are the default profile IDs documented anywhere?
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uIGGPvVGFHA.1068@.TK2MSFTNGP14.phx.gbl...
> from
> is
>
|||This also assumes that you haven't changed the default. The update below
would update the default merge agent.
update msdb.dbo.MSagent_parameters set value=120 where
parameter_name='-LoginTimeout' and
profile_id = ( select profile_id from msdb.dbo.MSagent_profiles where
agent_type=4 and def_profile = 1 )
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uIGGPvVGFHA.1068@.TK2MSFTNGP14.phx.gbl...
> here is an example of updating the merge default profile's LoginTimeOut
from[vbcol=seagreen]
> 15s to 120s.
>
> update msdb.dbo.MSagent_parameters set value=120 where
> parameter_name='-LoginTimeout' and profile_id=6
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Darren" <deo.is@.unknown.com> wrote in message
> news:%23$AjOiSGFHA.2568@.TK2MSFTNGP10.phx.gbl...
> change
is
>
|||That's probably a better way to do it
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Darren" <deo.is@.unknown.com> wrote in message
news:OkkNEVcGFHA.400@.TK2MSFTNGP14.phx.gbl...
> Or like this?
> sp_change_agent_parameter @.profile_id = 6, @.parameter_name =
> N'-UploadReadChangesPerBatch', @.parameter_value = N'2000'
> Are the default profile IDs documented anywhere?
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uIGGPvVGFHA.1068@.TK2MSFTNGP14.phx.gbl...
> from
> is
>

Default IIS Security Settings for RS?

What are the default directory security settings for each of the virtual
directories installed with RS?
/Reports
/ReportServer
In my quest to get authentication working properly I have changed 'em and
now they are totally broke.
If someone can help, it would be most appreciated.Integrated Windows Authentication.
--
Adrian M.
MCP
"Hunter Hillegas" <HunterHillegas@.discussions.microsoft.com> wrote in
message news:35464884-1C32-42B0-BC77-392E02A31B29@.microsoft.com...
> What are the default directory security settings for each of the virtual
> directories installed with RS?
> /Reports
> /ReportServer
> In my quest to get authentication working properly I have changed 'em and
> now they are totally broke.
> If someone can help, it would be most appreciated.sql

Default Encoding when saving a file in SSMS

Hi All

Is there a way (e.g. via Registry) to change the default encoding settings from UNICODE to a different encoding?

Thanks

Martin

Just want to know why you want it in registry hack way: http://blogs.msdn.com/sqlprogrammability/archive/2006/07/07/659375.aspx fyi.|||

Hi

Thanks for the reply. I understand what this blog is saying and most databases could switch to UNICODE and the errors in losing character information would have been resolved.

We are using software working with the ANSI standard. If I extract a stored procedure with the SSMS, fix or extend it, save it and distribute the stored procedure file with that tool to other databases, the tool fails unless I store it as an ANSI file not an UTF-16 (SSMS standard) file.

Therefore it would be very helpful for me if I could choose the default file format when saving files within the SSMS.

So I'm not exactly talking about the character standard of the database. I'm just having an issue with the default character format with the SSMS when saving a file.

Any idea how to resolve this?

Thanks

Martin

|||

I'm afraid there isn't a way to specify a different default encoding.

Please file your suggestion at http://connect.microsoft.com/sqlserver. When the development team is considering what features to implement, one of the criteria is whether a customer has actually requested it.

Thanks,

Steve

Default Encoding when saving a file in SSMS

Hi All

Is there a way (e.g. via Registry) to change the default encoding settings from UNICODE to a different encoding?

Thanks

Martin

Just want to know why you want it in registry hack way: http://blogs.msdn.com/sqlprogrammability/archive/2006/07/07/659375.aspx fyi.|||

Hi

Thanks for the reply. I understand what this blog is saying and most databases could switch to UNICODE and the errors in losing character information would have been resolved.

We are using software working with the ANSI standard. If I extract a stored procedure with the SSMS, fix or extend it, save it and distribute the stored procedure file with that tool to other databases, the tool fails unless I store it as an ANSI file not an UTF-16 (SSMS standard) file.

Therefore it would be very helpful for me if I could choose the default file format when saving files within the SSMS.

So I'm not exactly talking about the character standard of the database. I'm just having an issue with the default character format with the SSMS when saving a file.

Any idea how to resolve this?

Thanks

Martin

|||

I'm afraid there isn't a way to specify a different default encoding.

Please file your suggestion at http://connect.microsoft.com/sqlserver. When the development team is considering what features to implement, one of the criteria is whether a customer has actually requested it.

Thanks,

Steve

Default database location?

I have the default location for Data setup to be G:\Microsoft SQL
Server\Data (Database Settings under server properties).
But, when I invoke "Copy Database" from Management, it places the data on
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
Why doesn't the Copy Database Wizard respect my setting?
OlavOlav
It probably takes it from a model database
SELECT REPLACE(filename, 'model.mdf', '') FROM master..SysDatabases
WHERE [name] = 'model'
"Olav" <x@.y.com> wrote in message
news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>I have the default location for Data setup to be G:\Microsoft SQL
>Server\Data (Database Settings under server properties).
> But, when I invoke "Copy Database" from Management, it places the data on
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
> Why doesn't the Copy Database Wizard respect my setting?
> Olav
>|||I'm confused!
Why are there multiple places to configure the same kind of option?
Olav
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uUaZJ8WXGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Olav
> It probably takes it from a model database
> SELECT REPLACE(filename, 'model.mdf', '') FROM master..SysDatabases
> WHERE [name] = 'model'
>
>
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>|||You can view the default directory with the following :-
exec master..xp_regread
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft
\MSSQLServer\Setup','SQLDataRoot'
It can be changed with EnterPrise Manager, but... this change may not stick
as you need sufficient permsion to write to registry. If you find it isn't
saving you will need to logon to the box as administrator.
HTH. Ryan
"Olav" <x@.y.com> wrote in message
news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>I have the default location for Data setup to be G:\Microsoft SQL
>Server\Data (Database Settings under server properties).
> But, when I invoke "Copy Database" from Management, it places the data on
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
> Why doesn't the Copy Database Wizard respect my setting?
> Olav
>|||This is the result I got from the query on that machine:
RegQueryValueEx() returned error 2, 'The system cannot find the file
specified.'
Msg 22001, Level 1, State 1
(0 row(s) affected)
What does this indicate?
Olav
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uDgpjEXXGHA.1196@.TK2MSFTNGP03.phx.gbl...

> You can view the default directory with the following :-
> exec master..xp_regread
> 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft
\MSSQLServer\Setup','SQLDataRoot'
> It can be changed with EnterPrise Manager, but... this change may not
> stick as you need sufficient permsion to write to registry. If you find it
> isn't saving you will need to logon to the box as administrator.
> --
> HTH. Ryan
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>|||I checked in the Registry and it shows the following value for that key:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
In SQL Server Management Studio it shows:
G:\Microsoft SQL Server\Data
I'm still confused!
Why are there two different values for the same thing stored?
I'm running Management Studio logged in as an Administrator, so there should
be no problem writing to the registry.
Olav
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uDgpjEXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> You can view the default directory with the following :-
> exec master..xp_regread
> 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft
\MSSQLServer\Setup','SQLDataRoot'
> It can be changed with EnterPrise Manager, but... this change may not
> stick as you need sufficient permsion to write to registry. If you find it
> isn't saving you will need to logon to the box as administrator.
> --
> HTH. Ryan
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>

Default database location?

I have the default location for Data setup to be G:\Microsoft SQL
Server\Data (Database Settings under server properties).
But, when I invoke "Copy Database" from Management, it places the data on
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
Why doesn't the Copy Database Wizard respect my setting?
OlavOlav
It probably takes it from a model database
SELECT REPLACE(filename, 'model.mdf', '') FROM master..SysDatabases
WHERE [name] = 'model'
"Olav" <x@.y.com> wrote in message
news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>I have the default location for Data setup to be G:\Microsoft SQL
>Server\Data (Database Settings under server properties).
> But, when I invoke "Copy Database" from Management, it places the data on
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
> Why doesn't the Copy Database Wizard respect my setting?
> Olav
>|||I'm confused!
Why are there multiple places to configure the same kind of option?
Olav
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uUaZJ8WXGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Olav
> It probably takes it from a model database
> SELECT REPLACE(filename, 'model.mdf', '') FROM master..SysDatabases
> WHERE [name] = 'model'
>
>
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>>I have the default location for Data setup to be G:\Microsoft SQL
>>Server\Data (Database Settings under server properties).
>> But, when I invoke "Copy Database" from Management, it places the data on
>> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
>> Why doesn't the Copy Database Wizard respect my setting?
>> Olav
>|||You can view the default directory with the following :-
exec master..xp_regread
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLServer\Setup','SQLDataRoot'
It can be changed with EnterPrise Manager, but... this change may not stick
as you need sufficient permsion to write to registry. If you find it isn't
saving you will need to logon to the box as administrator.
--
HTH. Ryan
"Olav" <x@.y.com> wrote in message
news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>I have the default location for Data setup to be G:\Microsoft SQL
>Server\Data (Database Settings under server properties).
> But, when I invoke "Copy Database" from Management, it places the data on
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
> Why doesn't the Copy Database Wizard respect my setting?
> Olav
>|||This is the result I got from the query on that machine:
RegQueryValueEx() returned error 2, 'The system cannot find the file
specified.'
Msg 22001, Level 1, State 1
(0 row(s) affected)
What does this indicate?
Olav
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uDgpjEXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> You can view the default directory with the following :-
> exec master..xp_regread
> 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLServer\Setup','SQLDataRoot'
> It can be changed with EnterPrise Manager, but... this change may not
> stick as you need sufficient permsion to write to registry. If you find it
> isn't saving you will need to logon to the box as administrator.
> --
> HTH. Ryan
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>>I have the default location for Data setup to be G:\Microsoft SQL
>>Server\Data (Database Settings under server properties).
>> But, when I invoke "Copy Database" from Management, it places the data on
>> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
>> Why doesn't the Copy Database Wizard respect my setting?
>> Olav
>|||I checked in the Registry and it shows the following value for that key:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
In SQL Server Management Studio it shows:
G:\Microsoft SQL Server\Data
I'm still confused!
Why are there two different values for the same thing stored?
I'm running Management Studio logged in as an Administrator, so there should
be no problem writing to the registry.
Olav
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uDgpjEXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> You can view the default directory with the following :-
> exec master..xp_regread
> 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLServer\Setup','SQLDataRoot'
> It can be changed with EnterPrise Manager, but... this change may not
> stick as you need sufficient permsion to write to registry. If you find it
> isn't saving you will need to logon to the box as administrator.
> --
> HTH. Ryan
>
> "Olav" <x@.y.com> wrote in message
> news:%23xMVx0WXGHA.1348@.TK2MSFTNGP05.phx.gbl...
>>I have the default location for Data setup to be G:\Microsoft SQL
>>Server\Data (Database Settings under server properties).
>> But, when I invoke "Copy Database" from Management, it places the data on
>> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA.
>> Why doesn't the Copy Database Wizard respect my setting?
>> Olav
>

default affinitymask and affinityIOmask settings

Through the GUI for Server properties on my sql 2005 64 bit server,
I see that under processors, both set processor affinity mask and set IO
affinity mask are checked.
Is that the default ?
Also when I run
select name,value,value_in_use from sys.configurations where name like
'affinity%'
Output is as below :
affinity mask 0 0
affinity64 mask 0 0
affinity I/O mask 0 0
affinity64 I/O mask 0 0
So something does not add up. Is value the default and value_in_use the
current setting and if so, I would think that value_in_use should be 1.
I even restarted SQL. But it has the same results.Hi Hassan
All the of the affinity mask settings are bit MASKS, not just booleans. If
you set them to something non-zero, you are telling SQL Server which
processors to use. Each bit set means the corresponding processor will be
available to SQL Server.
The default is 0, which means that SQL Server will use all the available
processors.
Can you clarify what is 'set' in your GUI screen. I do not see anything that
says 'set processor affinity mask'; I have something that says
'Automatically set processor affinity mask for all processors' which is
basically telling SQL Server to use the 0 value, rather than having YOU
choose specific processors.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
> Through the GUI for Server properties on my sql 2005 64 bit server,
> I see that under processors, both set processor affinity mask and set IO
> affinity mask are checked.
> Is that the default ?
> Also when I run
> select name,value,value_in_use from sys.configurations where name like
> 'affinity%'
> Output is as below :
> affinity mask 0 0
> affinity64 mask 0 0
> affinity I/O mask 0 0
> affinity64 I/O mask 0 0
> So something does not add up. Is value the default and value_in_use the
> current setting and if so, I would think that value_in_use should be 1.
> I even restarted SQL. But it has the same results.
>
>|||Yes its the one you mentioned i.e. automatically set processor affinity mask
and automatically set IP affinity mask for all processors and they both are
checked for me.
Is that default ?
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
> Hi Hassan
> All the of the affinity mask settings are bit MASKS, not just booleans. If
> you set them to something non-zero, you are telling SQL Server which
> processors to use. Each bit set means the corresponding processor will be
> available to SQL Server.
> The default is 0, which means that SQL Server will use all the available
> processors.
> Can you clarify what is 'set' in your GUI screen. I do not see anything
> that says 'set processor affinity mask'; I have something that says
> 'Automatically set processor affinity mask for all processors' which is
> basically telling SQL Server to use the 0 value, rather than having YOU
> choose specific processors.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Hassan" <hassan@.hotmail.com> wrote in message
> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>> Through the GUI for Server properties on my sql 2005 64 bit server,
>> I see that under processors, both set processor affinity mask and set IO
>> affinity mask are checked.
>> Is that the default ?
>> Also when I run
>> select name,value,value_in_use from sys.configurations where name like
>> 'affinity%'
>> Output is as below :
>> affinity mask 0 0
>> affinity64 mask 0 0
>> affinity I/O mask 0 0
>> affinity64 I/O mask 0 0
>> So something does not add up. Is value the default and value_in_use the
>> current setting and if so, I would think that value_in_use should be 1.
>> I even restarted SQL. But it has the same results.
>>
>|||Yes
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:uFWlFM2PIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Yes its the one you mentioned i.e. automatically set processor affinity
> mask and automatically set IP affinity mask for all processors and they
> both are checked for me.
> Is that default ?
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
>> Hi Hassan
>> All the of the affinity mask settings are bit MASKS, not just booleans.
>> If you set them to something non-zero, you are telling SQL Server which
>> processors to use. Each bit set means the corresponding processor will
>> be available to SQL Server.
>> The default is 0, which means that SQL Server will use all the available
>> processors.
>> Can you clarify what is 'set' in your GUI screen. I do not see anything
>> that says 'set processor affinity mask'; I have something that says
>> 'Automatically set processor affinity mask for all processors' which is
>> basically telling SQL Server to use the 0 value, rather than having YOU
>> choose specific processors.
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.InsideSQLServer.com
>> http://sqlblog.com
>>
>> "Hassan" <hassan@.hotmail.com> wrote in message
>> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>> Through the GUI for Server properties on my sql 2005 64 bit server,
>> I see that under processors, both set processor affinity mask and set IO
>> affinity mask are checked.
>> Is that the default ?
>> Also when I run
>> select name,value,value_in_use from sys.configurations where name like
>> 'affinity%'
>> Output is as below :
>> affinity mask 0 0
>> affinity64 mask 0 0
>> affinity I/O mask 0 0
>> affinity64 I/O mask 0 0
>> So something does not add up. Is value the default and value_in_use the
>> current setting and if so, I would think that value_in_use should be 1.
>> I even restarted SQL. But it has the same results.
>>
>>
>

default affinitymask and affinityIOmask settings

Through the GUI for Server properties on my sql 2005 64 bit server,
I see that under processors, both set processor affinity mask and set IO
affinity mask are checked.
Is that the default ?
Also when I run
select name,value,value_in_use from sys.configurations where name like
'affinity%'
Output is as below :
affinity mask 0 0
affinity64 mask 0 0
affinity I/O mask 0 0
affinity64 I/O mask 0 0
So something does not add up. Is value the default and value_in_use the
current setting and if so, I would think that value_in_use should be 1.
I even restarted SQL. But it has the same results.
Hi Hassan
All the of the affinity mask settings are bit MASKS, not just booleans. If
you set them to something non-zero, you are telling SQL Server which
processors to use. Each bit set means the corresponding processor will be
available to SQL Server.
The default is 0, which means that SQL Server will use all the available
processors.
Can you clarify what is 'set' in your GUI screen. I do not see anything that
says 'set processor affinity mask'; I have something that says
'Automatically set processor affinity mask for all processors' which is
basically telling SQL Server to use the 0 value, rather than having YOU
choose specific processors.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
> Through the GUI for Server properties on my sql 2005 64 bit server,
> I see that under processors, both set processor affinity mask and set IO
> affinity mask are checked.
> Is that the default ?
> Also when I run
> select name,value,value_in_use from sys.configurations where name like
> 'affinity%'
> Output is as below :
> affinity mask 0 0
> affinity64 mask 0 0
> affinity I/O mask 0 0
> affinity64 I/O mask 0 0
> So something does not add up. Is value the default and value_in_use the
> current setting and if so, I would think that value_in_use should be 1.
> I even restarted SQL. But it has the same results.
>
>
|||Yes its the one you mentioned i.e. automatically set processor affinity mask
and automatically set IP affinity mask for all processors and they both are
checked for me.
Is that default ?
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
> Hi Hassan
> All the of the affinity mask settings are bit MASKS, not just booleans. If
> you set them to something non-zero, you are telling SQL Server which
> processors to use. Each bit set means the corresponding processor will be
> available to SQL Server.
> The default is 0, which means that SQL Server will use all the available
> processors.
> Can you clarify what is 'set' in your GUI screen. I do not see anything
> that says 'set processor affinity mask'; I have something that says
> 'Automatically set processor affinity mask for all processors' which is
> basically telling SQL Server to use the 0 value, rather than having YOU
> choose specific processors.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Hassan" <hassan@.hotmail.com> wrote in message
> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>
|||Yes
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:uFWlFM2PIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Yes its the one you mentioned i.e. automatically set processor affinity
> mask and automatically set IP affinity mask for all processors and they
> both are checked for me.
> Is that default ?
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
>

default affinitymask and affinityIOmask settings

Through the GUI for Server properties on my sql 2005 64 bit server,
I see that under processors, both set processor affinity mask and set IO
affinity mask are checked.
Is that the default ?
Also when I run
select name,value,value_in_use from sys.configurations where name like
'affinity%'
Output is as below :
affinity mask 0 0
affinity64 mask 0 0
affinity I/O mask 0 0
affinity64 I/O mask 0 0
So something does not add up. Is value the default and value_in_use the
current setting and if so, I would think that value_in_use should be 1.
I even restarted SQL. But it has the same results.Hi Hassan
All the of the affinity mask settings are bit MASKS, not just booleans. If
you set them to something non-zero, you are telling SQL Server which
processors to use. Each bit set means the corresponding processor will be
available to SQL Server.
The default is 0, which means that SQL Server will use all the available
processors.
Can you clarify what is 'set' in your GUI screen. I do not see anything that
says 'set processor affinity mask'; I have something that says
'Automatically set processor affinity mask for all processors' which is
basically telling SQL Server to use the 0 value, rather than having YOU
choose specific processors.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
> Through the GUI for Server properties on my sql 2005 64 bit server,
> I see that under processors, both set processor affinity mask and set IO
> affinity mask are checked.
> Is that the default ?
> Also when I run
> select name,value,value_in_use from sys.configurations where name like
> 'affinity%'
> Output is as below :
> affinity mask 0 0
> affinity64 mask 0 0
> affinity I/O mask 0 0
> affinity64 I/O mask 0 0
> So something does not add up. Is value the default and value_in_use the
> current setting and if so, I would think that value_in_use should be 1.
> I even restarted SQL. But it has the same results.
>
>|||Yes its the one you mentioned i.e. automatically set processor affinity mask
and automatically set IP affinity mask for all processors and they both are
checked for me.
Is that default ?
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
> Hi Hassan
> All the of the affinity mask settings are bit MASKS, not just booleans. If
> you set them to something non-zero, you are telling SQL Server which
> processors to use. Each bit set means the corresponding processor will be
> available to SQL Server.
> The default is 0, which means that SQL Server will use all the available
> processors.
> Can you clarify what is 'set' in your GUI screen. I do not see anything
> that says 'set processor affinity mask'; I have something that says
> 'Automatically set processor affinity mask for all processors' which is
> basically telling SQL Server to use the 0 value, rather than having YOU
> choose specific processors.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Hassan" <hassan@.hotmail.com> wrote in message
> news:%23uQjBN1PIHA.3676@.TK2MSFTNGP06.phx.gbl...
>|||Yes
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Hassan" <hassan@.hotmail.com> wrote in message
news:uFWlFM2PIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Yes its the one you mentioned i.e. automatically set processor affinity
> mask and automatically set IP affinity mask for all processors and they
> both are checked for me.
> Is that default ?
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:uHu4ih1PIHA.5016@.TK2MSFTNGP06.phx.gbl...
>