Hi,
Hw can I create a linked server between 2 sql server databases in diferente
machines?
How can I indicate the 2 catalogs and the 2 servers?
Thanks in advance
PedroThe syntax is:
[LINKEDSERVER].[Databasename].[owner].[Objectname]
e.g. Select * from [LINKEDSERVER].[Databasename].[owner].[Objectname]
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Pedro" <Pedro@.discussions.microsoft.com> wrote in message
news:B828F7E5-C4A1-41B2-9717-D1DC9433B6DB@.microsoft.com...
> Hi,
> Hw can I create a linked server between 2 sql server databases in
> diferente
> machines?
> How can I indicate the 2 catalogs and the 2 servers?
> Thanks in advance
> Pedro|||Hi Jens,
My question is how can I create a linkedserver.
Imagine that I have 2 sql server's, SQLSERVER1 with a catalog BOOK and
SQLSERVER2 with a catalog PUBLISHER.
I want to link this to server so I can have a trigger on a table of the BOOK
database on SQLSERVER1 invoke a storeprocedure of database PUBLISHER on
SQLSERVER2
How can I do this?
How can I setup this kind of linkedserver?
On Entreprise manager I can add a linkedserver chose "SQL Server" but I
can't setup the address of the 2 servers or the 2 databases on that 2
servers.
"Jens Sü�meyer" wrote:
> The syntax is:
> [LINKEDSERVER].[Databasename].[owner].[Objectname]
> e.g. Select * from [LINKEDSERVER].[Databasename].[owner].[Objectname]
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Pedro" <Pedro@.discussions.microsoft.com> wrote in message
> news:B828F7E5-C4A1-41B2-9717-D1DC9433B6DB@.microsoft.com...
> > Hi,
> >
> > Hw can I create a linked server between 2 sql server databases in
> > diferente
> > machines?
> > How can I indicate the 2 catalogs and the 2 servers?
> >
> > Thanks in advance
> >
> > Pedro
>
>|||I wouldn=B4t do that, trigegr behave synchron, they wait for the
transaction started, so if the line between the servers isn=B4t setup
properly or the other server doesn=B4t repsond you will get into trouble
because the transaction is rolled back.
Anyway, the name of the server (in the menu of the linkedserver) is the
name of the server/instance. The database can be reached with the above
mentioned 4 part notation.
otherwise you could use the sp_addlinkedserver command which can be
found (with samples) int he BOL.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--sql
Showing posts with label servers. Show all posts
Showing posts with label servers. Show all posts
Thursday, March 22, 2012
create a database called DBA_Status (was "Question!")
Is it possible to create a database on a server called DBA_Status, and keep status of every database and servers that you are responsible for or do I have to created a DBA_Status on every server that I am responsible for?
Thanksformer yes. you can manage alerts for multiple servers from one server. under automating administrative tasks in SQL Server Books Online there are topics covering multi-serrver administration and centralizing alerts and writing to the error logs and such.
Thanksformer yes. you can manage alerts for multiple servers from one server. under automating administrative tasks in SQL Server Books Online there are topics covering multi-serrver administration and centralizing alerts and writing to the error logs and such.
Tuesday, March 20, 2012
Create (U)SP in database on linked server
Hi,
I'm using a couple of linked servers.
I want to create a stored procedure on all of the linked servers in a database with a name which exists on all of the linked servers.
For executing SQL on all of the linked servers I'm using:
declare @.x int
declare @.dbname varchar(500)
declare @.SQL nvarchar(600)
set @.x = 1
create table #databases (ID int IDENTITY,name varchar(500))
insert #databases select instancelongname from instances
while @.x <= (select max(id) from #databases)
begin
select @.dbname = name from #databases where id = @.x
select @.SQL='blabla bla bla create PROCEDURE [dbo].[usp_xxxx]'
execute @.SQL
set @.x = @.x + 1
end
drop table #databases
Is it possible to use a create procedure in this construction?
Can anybody give me some help how to create a proper syntax for it?
Any help is kindly appreciated!Your code assumes that the database IDs are sequential and continuous, which they are probably not, so you are going to generate a lot of errors with this. But as far as creating the sprocs, your dynamic SQL will need to start with a USE statement to set the scope to your target database.
I'm using a couple of linked servers.
I want to create a stored procedure on all of the linked servers in a database with a name which exists on all of the linked servers.
For executing SQL on all of the linked servers I'm using:
declare @.x int
declare @.dbname varchar(500)
declare @.SQL nvarchar(600)
set @.x = 1
create table #databases (ID int IDENTITY,name varchar(500))
insert #databases select instancelongname from instances
while @.x <= (select max(id) from #databases)
begin
select @.dbname = name from #databases where id = @.x
select @.SQL='blabla bla bla create PROCEDURE [dbo].[usp_xxxx]'
execute @.SQL
set @.x = @.x + 1
end
drop table #databases
Is it possible to use a create procedure in this construction?
Can anybody give me some help how to create a proper syntax for it?
Any help is kindly appreciated!Your code assumes that the database IDs are sequential and continuous, which they are probably not, so you are going to generate a lot of errors with this. But as far as creating the sprocs, your dynamic SQL will need to start with a USE statement to set the scope to your target database.
Monday, March 19, 2012
Crashing server (Event ID 333)
Hello,
We experience problems with machines running SQL Servers 2005 in our
production environment. This problem is rather connected to OS or network
settings but hopefully someone here can help. The error below appears several
times in a minute and leads to crash of a machine.
We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server 2005
SP2. This problem started to occur after installation of automatic updates
(bunch of security updates).
Has anyone solved similar issue? Could someone help to track down the problem?
Many thanks
eXavier
Event Type:Error
Event Source:Application Popup
Event Category:None
Event ID:333
Date:07.04.2008
Time:09:01:57
User:N/A
Computer:CMPNT45
Description:
An I/O operation initiated by the Registry failed unrecoverably. The
Registry could not read in, or write out, or flush, one of the files that
contain the system's image of the Registry.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00 00 00 00 01 00 6c 00 .....l.
0008: 00 00 00 00 4d 01 00 c0 ...M..à
0010: 00 00 00 00 4d 01 00 c0 ...M..à
0018: 00 00 00 00 00 00 00 00 ......
0020: 00 00 00 00 00 00 00 00 ......
I am a consultant by trade and help people with SQL Server problems for a
living. But I gotta say when something like this occurs MY first action
would be (and my advice to my clients would be) call Microsoft PSS!!
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"eXavier" <eXavier@.nospam.nospam> wrote in message
news:70DC487A-4928-40E1-9DC0-59FB0AB1B5AB@.microsoft.com...
> Hello,
> We experience problems with machines running SQL Servers 2005 in our
> production environment. This problem is rather connected to OS or network
> settings but hopefully someone here can help. The error below appears
> several
> times in a minute and leads to crash of a machine.
> We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server
> 2005
> SP2. This problem started to occur after installation of automatic updates
> (bunch of security updates).
> Has anyone solved similar issue? Could someone help to track down the
> problem?
> Many thanks
> eXavier
>
> Event Type: Error
> Event Source: Application Popup
> Event Category: None
> Event ID: 333
> Date: 07.04.2008
> Time: 09:01:57
> User: N/A
> Computer: CMPNT45
> Description:
> An I/O operation initiated by the Registry failed unrecoverably. The
> Registry could not read in, or write out, or flush, one of the files that
> contain the system's image of the Registry.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 00 00 00 00 01 00 6c 00 .....l.
> 0008: 00 00 00 00 4d 01 00 c0 ...M..
> 0010: 00 00 00 00 4d 01 00 c0 ...M..
> 0018: 00 00 00 00 00 00 00 00 ......
> 0020: 00 00 00 00 00 00 00 00 ......
>
|||Hello,
I agree with Kevin it's best taht you call MS PSS for memory dump analysis
on this server crash issue. For a complete list of Microsoft Product
Support Services phone numbers, please go to the following address on the
World Wide Web:
http://support.microsoft.com/directory/overview.asp
Also, you may want to use add/edit the following registry key to see if it
helps
In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Contro l\Session
Manager\Configuration Manager subkey, configure the following entry:
Name: RegistryLazyFlushInterval
Data Type: REG_DWORD
Value data: 60 (decimal)
You may try to increase Windows paging file size to see if it's helpful.
It's possible that this kind of issue occurs when there are some issues
related to server hardware driver. For example, if the operating system
cannot satisfy the contiguous memory blocks under the 4 GB space, the
server may become unresponsive.
Reference the following HP site details:
http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
objectID
=c00688313&jumpid=reg_R1002_USEN
Please let's know if you have any further questions or comments. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up responske may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hello,
It seems the problem was really caused by drivers for extra sotrage added
during maintenace period.
Thanks for all responses!
Best Regards
eXavier
""Peter Yang[MSFT]"" wrote:
> Hello,
> I agree with Kevin it's best taht you call MS PSS for memory dump analysis
> on this server crash issue. For a complete list of Microsoft Product
> Support Services phone numbers, please go to the following address on the
> World Wide Web:
> http://support.microsoft.com/directory/overview.asp
>
> Also, you may want to use add/edit the following registry key to see if it
> helps
> In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Contro l\Session
> Manager\Configuration Manager subkey, configure the following entry:
> Name: RegistryLazyFlushInterval
> Data Type: REG_DWORD
> Value data: 60 (decimal)
> You may try to increase Windows paging file size to see if it's helpful.
> It's possible that this kind of issue occurs when there are some issues
> related to server hardware driver. For example, if the operating system
> cannot satisfy the contiguous memory blocks under the 4 GB space, the
> server may become unresponsive.
> Reference the following HP site details:
> http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
> objectID
> =c00688313&jumpid=reg_R1002_USEN
> Please let's know if you have any further questions or comments. Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up responske may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hello,
Nice to hear you solved the problem!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
We experience problems with machines running SQL Servers 2005 in our
production environment. This problem is rather connected to OS or network
settings but hopefully someone here can help. The error below appears several
times in a minute and leads to crash of a machine.
We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server 2005
SP2. This problem started to occur after installation of automatic updates
(bunch of security updates).
Has anyone solved similar issue? Could someone help to track down the problem?
Many thanks
eXavier
Event Type:Error
Event Source:Application Popup
Event Category:None
Event ID:333
Date:07.04.2008
Time:09:01:57
User:N/A
Computer:CMPNT45
Description:
An I/O operation initiated by the Registry failed unrecoverably. The
Registry could not read in, or write out, or flush, one of the files that
contain the system's image of the Registry.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00 00 00 00 01 00 6c 00 .....l.
0008: 00 00 00 00 4d 01 00 c0 ...M..à
0010: 00 00 00 00 4d 01 00 c0 ...M..à
0018: 00 00 00 00 00 00 00 00 ......
0020: 00 00 00 00 00 00 00 00 ......
I am a consultant by trade and help people with SQL Server problems for a
living. But I gotta say when something like this occurs MY first action
would be (and my advice to my clients would be) call Microsoft PSS!!
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"eXavier" <eXavier@.nospam.nospam> wrote in message
news:70DC487A-4928-40E1-9DC0-59FB0AB1B5AB@.microsoft.com...
> Hello,
> We experience problems with machines running SQL Servers 2005 in our
> production environment. This problem is rather connected to OS or network
> settings but hopefully someone here can help. The error below appears
> several
> times in a minute and leads to crash of a machine.
> We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server
> 2005
> SP2. This problem started to occur after installation of automatic updates
> (bunch of security updates).
> Has anyone solved similar issue? Could someone help to track down the
> problem?
> Many thanks
> eXavier
>
> Event Type: Error
> Event Source: Application Popup
> Event Category: None
> Event ID: 333
> Date: 07.04.2008
> Time: 09:01:57
> User: N/A
> Computer: CMPNT45
> Description:
> An I/O operation initiated by the Registry failed unrecoverably. The
> Registry could not read in, or write out, or flush, one of the files that
> contain the system's image of the Registry.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 00 00 00 00 01 00 6c 00 .....l.
> 0008: 00 00 00 00 4d 01 00 c0 ...M..
> 0010: 00 00 00 00 4d 01 00 c0 ...M..
> 0018: 00 00 00 00 00 00 00 00 ......
> 0020: 00 00 00 00 00 00 00 00 ......
>
|||Hello,
I agree with Kevin it's best taht you call MS PSS for memory dump analysis
on this server crash issue. For a complete list of Microsoft Product
Support Services phone numbers, please go to the following address on the
World Wide Web:
http://support.microsoft.com/directory/overview.asp
Also, you may want to use add/edit the following registry key to see if it
helps
In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Contro l\Session
Manager\Configuration Manager subkey, configure the following entry:
Name: RegistryLazyFlushInterval
Data Type: REG_DWORD
Value data: 60 (decimal)
You may try to increase Windows paging file size to see if it's helpful.
It's possible that this kind of issue occurs when there are some issues
related to server hardware driver. For example, if the operating system
cannot satisfy the contiguous memory blocks under the 4 GB space, the
server may become unresponsive.
Reference the following HP site details:
http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
objectID
=c00688313&jumpid=reg_R1002_USEN
Please let's know if you have any further questions or comments. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up responske may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hello,
It seems the problem was really caused by drivers for extra sotrage added
during maintenace period.
Thanks for all responses!
Best Regards
eXavier
""Peter Yang[MSFT]"" wrote:
> Hello,
> I agree with Kevin it's best taht you call MS PSS for memory dump analysis
> on this server crash issue. For a complete list of Microsoft Product
> Support Services phone numbers, please go to the following address on the
> World Wide Web:
> http://support.microsoft.com/directory/overview.asp
>
> Also, you may want to use add/edit the following registry key to see if it
> helps
> In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Contro l\Session
> Manager\Configuration Manager subkey, configure the following entry:
> Name: RegistryLazyFlushInterval
> Data Type: REG_DWORD
> Value data: 60 (decimal)
> You may try to increase Windows paging file size to see if it's helpful.
> It's possible that this kind of issue occurs when there are some issues
> related to server hardware driver. For example, if the operating system
> cannot satisfy the contiguous memory blocks under the 4 GB space, the
> server may become unresponsive.
> Reference the following HP site details:
> http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
> objectID
> =c00688313&jumpid=reg_R1002_USEN
> Please let's know if you have any further questions or comments. Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up responske may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hello,
Nice to hear you solved the problem!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
Crashing server (Event ID 333)
Hello,
We experience problems with machines running SQL Servers 2005 in our
production environment. This problem is rather connected to OS or network
settings but hopefully someone here can help. The error below appears several
times in a minute and leads to crash of a machine.
We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server 2005
SP2. This problem started to occur after installation of automatic updates
(bunch of security updates).
Has anyone solved similar issue? Could someone help to track down the problem?
Many thanks
eXavier
Event Type: Error
Event Source: Application Popup
Event Category: None
Event ID: 333
Date: 07.04.2008
Time: 09:01:57
User: N/A
Computer: CMPNT45
Description:
An I/O operation initiated by the Registry failed unrecoverably. The
Registry could not read in, or write out, or flush, one of the files that
contain the system's image of the Registry.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00 00 00 00 01 00 6c 00 .....l.
0008: 00 00 00 00 4d 01 00 c0 ...M..Ã?
0010: 00 00 00 00 4d 01 00 c0 ...M..Ã?
0018: 00 00 00 00 00 00 00 00 ......
0020: 00 00 00 00 00 00 00 00 ......I am a consultant by trade and help people with SQL Server problems for a
living. But I gotta say when something like this occurs MY first action
would be (and my advice to my clients would be) call Microsoft PSS!! :)
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"eXavier" <eXavier@.nospam.nospam> wrote in message
news:70DC487A-4928-40E1-9DC0-59FB0AB1B5AB@.microsoft.com...
> Hello,
> We experience problems with machines running SQL Servers 2005 in our
> production environment. This problem is rather connected to OS or network
> settings but hopefully someone here can help. The error below appears
> several
> times in a minute and leads to crash of a machine.
> We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server
> 2005
> SP2. This problem started to occur after installation of automatic updates
> (bunch of security updates).
> Has anyone solved similar issue? Could someone help to track down the
> problem?
> Many thanks
> eXavier
>
> Event Type: Error
> Event Source: Application Popup
> Event Category: None
> Event ID: 333
> Date: 07.04.2008
> Time: 09:01:57
> User: N/A
> Computer: CMPNT45
> Description:
> An I/O operation initiated by the Registry failed unrecoverably. The
> Registry could not read in, or write out, or flush, one of the files that
> contain the system's image of the Registry.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 00 00 00 00 01 00 6c 00 .....l.
> 0008: 00 00 00 00 4d 01 00 c0 ...M..À
> 0010: 00 00 00 00 4d 01 00 c0 ...M..À
> 0018: 00 00 00 00 00 00 00 00 ......
> 0020: 00 00 00 00 00 00 00 00 ......
>|||Hello,
I agree with Kevin it's best taht you call MS PSS for memory dump analysis
on this server crash issue. For a complete list of Microsoft Product
Support Services phone numbers, please go to the following address on the
World Wide Web:
http://support.microsoft.com/directory/overview.asp
Also, you may want to use add/edit the following registry key to see if it
helps
In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session
Manager\Configuration Manager subkey, configure the following entry:
Name: RegistryLazyFlushInterval
Data Type: REG_DWORD
Value data: 60 (decimal)
You may try to increase Windows paging file size to see if it's helpful.
It's possible that this kind of issue occurs when there are some issues
related to server hardware driver. For example, if the operating system
cannot satisfy the contiguous memory blocks under the 4 GB space, the
server may become unresponsive.
Reference the following HP site details:
http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
objectID
=c00688313&jumpid=reg_R1002_USEN
Please let's know if you have any further questions or comments. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up responske may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
It seems the problem was really caused by drivers for extra sotrage added
during maintenace period.
Thanks for all responses!
Best Regards
eXavier
""Peter Yang[MSFT]"" wrote:
> Hello,
> I agree with Kevin it's best taht you call MS PSS for memory dump analysis
> on this server crash issue. For a complete list of Microsoft Product
> Support Services phone numbers, please go to the following address on the
> World Wide Web:
> http://support.microsoft.com/directory/overview.asp
>
> Also, you may want to use add/edit the following registry key to see if it
> helps
> In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session
> Manager\Configuration Manager subkey, configure the following entry:
> Name: RegistryLazyFlushInterval
> Data Type: REG_DWORD
> Value data: 60 (decimal)
> You may try to increase Windows paging file size to see if it's helpful.
> It's possible that this kind of issue occurs when there are some issues
> related to server hardware driver. For example, if the operating system
> cannot satisfy the contiguous memory blocks under the 4 GB space, the
> server may become unresponsive.
> Reference the following HP site details:
> http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
> objectID
> =c00688313&jumpid=reg_R1002_USEN
> Please let's know if you have any further questions or comments. Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up responske may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello,
Nice to hear you solved the problem!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
We experience problems with machines running SQL Servers 2005 in our
production environment. This problem is rather connected to OS or network
settings but hopefully someone here can help. The error below appears several
times in a minute and leads to crash of a machine.
We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server 2005
SP2. This problem started to occur after installation of automatic updates
(bunch of security updates).
Has anyone solved similar issue? Could someone help to track down the problem?
Many thanks
eXavier
Event Type: Error
Event Source: Application Popup
Event Category: None
Event ID: 333
Date: 07.04.2008
Time: 09:01:57
User: N/A
Computer: CMPNT45
Description:
An I/O operation initiated by the Registry failed unrecoverably. The
Registry could not read in, or write out, or flush, one of the files that
contain the system's image of the Registry.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00 00 00 00 01 00 6c 00 .....l.
0008: 00 00 00 00 4d 01 00 c0 ...M..Ã?
0010: 00 00 00 00 4d 01 00 c0 ...M..Ã?
0018: 00 00 00 00 00 00 00 00 ......
0020: 00 00 00 00 00 00 00 00 ......I am a consultant by trade and help people with SQL Server problems for a
living. But I gotta say when something like this occurs MY first action
would be (and my advice to my clients would be) call Microsoft PSS!! :)
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"eXavier" <eXavier@.nospam.nospam> wrote in message
news:70DC487A-4928-40E1-9DC0-59FB0AB1B5AB@.microsoft.com...
> Hello,
> We experience problems with machines running SQL Servers 2005 in our
> production environment. This problem is rather connected to OS or network
> settings but hopefully someone here can help. The error below appears
> several
> times in a minute and leads to crash of a machine.
> We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server
> 2005
> SP2. This problem started to occur after installation of automatic updates
> (bunch of security updates).
> Has anyone solved similar issue? Could someone help to track down the
> problem?
> Many thanks
> eXavier
>
> Event Type: Error
> Event Source: Application Popup
> Event Category: None
> Event ID: 333
> Date: 07.04.2008
> Time: 09:01:57
> User: N/A
> Computer: CMPNT45
> Description:
> An I/O operation initiated by the Registry failed unrecoverably. The
> Registry could not read in, or write out, or flush, one of the files that
> contain the system's image of the Registry.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 00 00 00 00 01 00 6c 00 .....l.
> 0008: 00 00 00 00 4d 01 00 c0 ...M..À
> 0010: 00 00 00 00 4d 01 00 c0 ...M..À
> 0018: 00 00 00 00 00 00 00 00 ......
> 0020: 00 00 00 00 00 00 00 00 ......
>|||Hello,
I agree with Kevin it's best taht you call MS PSS for memory dump analysis
on this server crash issue. For a complete list of Microsoft Product
Support Services phone numbers, please go to the following address on the
World Wide Web:
http://support.microsoft.com/directory/overview.asp
Also, you may want to use add/edit the following registry key to see if it
helps
In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session
Manager\Configuration Manager subkey, configure the following entry:
Name: RegistryLazyFlushInterval
Data Type: REG_DWORD
Value data: 60 (decimal)
You may try to increase Windows paging file size to see if it's helpful.
It's possible that this kind of issue occurs when there are some issues
related to server hardware driver. For example, if the operating system
cannot satisfy the contiguous memory blocks under the 4 GB space, the
server may become unresponsive.
Reference the following HP site details:
http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
objectID
=c00688313&jumpid=reg_R1002_USEN
Please let's know if you have any further questions or comments. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up responske may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
It seems the problem was really caused by drivers for extra sotrage added
during maintenace period.
Thanks for all responses!
Best Regards
eXavier
""Peter Yang[MSFT]"" wrote:
> Hello,
> I agree with Kevin it's best taht you call MS PSS for memory dump analysis
> on this server crash issue. For a complete list of Microsoft Product
> Support Services phone numbers, please go to the following address on the
> World Wide Web:
> http://support.microsoft.com/directory/overview.asp
>
> Also, you may want to use add/edit the following registry key to see if it
> helps
> In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session
> Manager\Configuration Manager subkey, configure the following entry:
> Name: RegistryLazyFlushInterval
> Data Type: REG_DWORD
> Value data: 60 (decimal)
> You may try to increase Windows paging file size to see if it's helpful.
> It's possible that this kind of issue occurs when there are some issues
> related to server hardware driver. For example, if the operating system
> cannot satisfy the contiguous memory blocks under the 4 GB space, the
> server may become unresponsive.
> Reference the following HP site details:
> http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
> objectID
> =c00688313&jumpid=reg_R1002_USEN
> Please let's know if you have any further questions or comments. Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up responske may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello,
Nice to hear you solved the problem!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Crashing a server
Hi,
First of all I want to know if there is a manual way of crashing a server.
My second question -
I have two Standard Edition SQL Servers one(S1) running the production databases, and the other(S2) is just a standby. The database files are on a DISK array. Suppose if S1 crashes, can I point to the S2 Server to the same DISK array and use sp_attch sp's
to bring the database up.
Thanks,
Elvis
Have yo tried poring coke on the motherboard? That would crash the server
pretty good... you might want to explain what particular behairor you want
to cause to happen and then perhaps someone could offer good advice about
how to achieve it...
About the sp_attach...
there are a few issues.
1. Is it shared in some kind of cluster or SAN? Databases in SQL need to be
on local drives. So, you can't simply attach if the files are on a drive
that looks like a network drive to SQL.
2. If S1 goes down in an uncontrolled manner... the files themselves may be
damaged. Even if they're not damages... you can't guarantee the ability to
do an attach unless you had first done a detach. So... know... this doesn't
sound like a great solutioin.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Elvis Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:FA9EB5D2-AB32-4903-B270-DC5F6C2AC09C@.microsoft.com...
> Hi,
> First of all I want to know if there is a manual way of crashing a server.
> My second question -
> I have two Standard Edition SQL Servers one(S1) running the production
databases, and the other(S2) is just a standby. The database files are on a
DISK array. Suppose if S1 crashes, can I point to the S2 Server to the same
DISK array and use sp_attch sp's to bring the database up.
> Thanks,
> Elvis
First of all I want to know if there is a manual way of crashing a server.
My second question -
I have two Standard Edition SQL Servers one(S1) running the production databases, and the other(S2) is just a standby. The database files are on a DISK array. Suppose if S1 crashes, can I point to the S2 Server to the same DISK array and use sp_attch sp's
to bring the database up.
Thanks,
Elvis
Have yo tried poring coke on the motherboard? That would crash the server
pretty good... you might want to explain what particular behairor you want
to cause to happen and then perhaps someone could offer good advice about
how to achieve it...
About the sp_attach...
there are a few issues.
1. Is it shared in some kind of cluster or SAN? Databases in SQL need to be
on local drives. So, you can't simply attach if the files are on a drive
that looks like a network drive to SQL.
2. If S1 goes down in an uncontrolled manner... the files themselves may be
damaged. Even if they're not damages... you can't guarantee the ability to
do an attach unless you had first done a detach. So... know... this doesn't
sound like a great solutioin.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Elvis Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:FA9EB5D2-AB32-4903-B270-DC5F6C2AC09C@.microsoft.com...
> Hi,
> First of all I want to know if there is a manual way of crashing a server.
> My second question -
> I have two Standard Edition SQL Servers one(S1) running the production
databases, and the other(S2) is just a standby. The database files are on a
DISK array. Suppose if S1 crashes, can I point to the S2 Server to the same
DISK array and use sp_attch sp's to bring the database up.
> Thanks,
> Elvis
Crashing a server
Hi,
First of all I want to know if there is a manual way of crashing a server.
My second question -
I have two Standard Edition SQL Servers one(S1) running the production datab
ases, and the other(S2) is just a standby. The database files are on a DISK
array. Suppose if S1 crashes, can I point to the S2 Server to the same DISK
array and use sp_attch sp's
to bring the database up.
Thanks,
ElvisHave yo tried poring coke on the motherboard? That would crash the server
pretty good... you might want to explain what particular behairor you want
to cause to happen and then perhaps someone could offer good advice about
how to achieve it...
About the sp_attach...
there are a few issues.
1. Is it shared in some kind of cluster or SAN? Databases in SQL need to be
on local drives. So, you can't simply attach if the files are on a drive
that looks like a network drive to SQL.
2. If S1 goes down in an uncontrolled manner... the files themselves may be
damaged. Even if they're not damages... you can't guarantee the ability to
do an attach unless you had first done a detach. So... know... this doesn't
sound like a great solutioin.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Elvis Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:FA9EB5D2-AB32-4903-B270-DC5F6C2AC09C@.microsoft.com...
> Hi,
> First of all I want to know if there is a manual way of crashing a server.
> My second question -
> I have two Standard Edition SQL Servers one(S1) running the production
databases, and the other(S2) is just a standby. The database files are on a
DISK array. Suppose if S1 crashes, can I point to the S2 Server to the same
DISK array and use sp_attch sp's to bring the database up.
> Thanks,
> Elvis
First of all I want to know if there is a manual way of crashing a server.
My second question -
I have two Standard Edition SQL Servers one(S1) running the production datab
ases, and the other(S2) is just a standby. The database files are on a DISK
array. Suppose if S1 crashes, can I point to the S2 Server to the same DISK
array and use sp_attch sp's
to bring the database up.
Thanks,
ElvisHave yo tried poring coke on the motherboard? That would crash the server
pretty good... you might want to explain what particular behairor you want
to cause to happen and then perhaps someone could offer good advice about
how to achieve it...
About the sp_attach...
there are a few issues.
1. Is it shared in some kind of cluster or SAN? Databases in SQL need to be
on local drives. So, you can't simply attach if the files are on a drive
that looks like a network drive to SQL.
2. If S1 goes down in an uncontrolled manner... the files themselves may be
damaged. Even if they're not damages... you can't guarantee the ability to
do an attach unless you had first done a detach. So... know... this doesn't
sound like a great solutioin.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Elvis Clinton" <anonymous@.discussions.microsoft.com> wrote in message
news:FA9EB5D2-AB32-4903-B270-DC5F6C2AC09C@.microsoft.com...
> Hi,
> First of all I want to know if there is a manual way of crashing a server.
> My second question -
> I have two Standard Edition SQL Servers one(S1) running the production
databases, and the other(S2) is just a standby. The database files are on a
DISK array. Suppose if S1 crashes, can I point to the S2 Server to the same
DISK array and use sp_attch sp's to bring the database up.
> Thanks,
> Elvis
Thursday, March 8, 2012
CPU Use Rising
Hello Group,
what is a good starting point setting a trace to troubleshoot CPU usage? My
network admin asked me to look at one of the servers: it seems after our
weekly restarts, the CPU usage keeps rising. What can I begin to look at to
determine what is causing this?Rich,
Start with Task Manager to determine what app is causing the issue. If SQL
Server, then drill down using System Monitor and Profiler.
HTH
Jerry
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:B55F66D8-C41D-4C04-9BC6-87F176891311@.microsoft.com...
> Hello Group,
> what is a good starting point setting a trace to troubleshoot CPU usage?
> My
> network admin asked me to look at one of the servers: it seems after our
> weekly restarts, the CPU usage keeps rising. What can I begin to look at
> to
> determine what is causing this?
what is a good starting point setting a trace to troubleshoot CPU usage? My
network admin asked me to look at one of the servers: it seems after our
weekly restarts, the CPU usage keeps rising. What can I begin to look at to
determine what is causing this?Rich,
Start with Task Manager to determine what app is causing the issue. If SQL
Server, then drill down using System Monitor and Profiler.
HTH
Jerry
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:B55F66D8-C41D-4C04-9BC6-87F176891311@.microsoft.com...
> Hello Group,
> what is a good starting point setting a trace to troubleshoot CPU usage?
> My
> network admin asked me to look at one of the servers: it seems after our
> weekly restarts, the CPU usage keeps rising. What can I begin to look at
> to
> determine what is causing this?
CPU Use Rising
Hello Group,
what is a good starting point setting a trace to troubleshoot CPU usage? My
network admin asked me to look at one of the servers: it seems after our
weekly restarts, the CPU usage keeps rising. What can I begin to look at to
determine what is causing this?
Rich,
Start with Task Manager to determine what app is causing the issue. If SQL
Server, then drill down using System Monitor and Profiler.
HTH
Jerry
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:B55F66D8-C41D-4C04-9BC6-87F176891311@.microsoft.com...
> Hello Group,
> what is a good starting point setting a trace to troubleshoot CPU usage?
> My
> network admin asked me to look at one of the servers: it seems after our
> weekly restarts, the CPU usage keeps rising. What can I begin to look at
> to
> determine what is causing this?
what is a good starting point setting a trace to troubleshoot CPU usage? My
network admin asked me to look at one of the servers: it seems after our
weekly restarts, the CPU usage keeps rising. What can I begin to look at to
determine what is causing this?
Rich,
Start with Task Manager to determine what app is causing the issue. If SQL
Server, then drill down using System Monitor and Profiler.
HTH
Jerry
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:B55F66D8-C41D-4C04-9BC6-87F176891311@.microsoft.com...
> Hello Group,
> what is a good starting point setting a trace to troubleshoot CPU usage?
> My
> network admin asked me to look at one of the servers: it seems after our
> weekly restarts, the CPU usage keeps rising. What can I begin to look at
> to
> determine what is causing this?
CPU Use Rising
Hello Group,
what is a good starting point setting a trace to troubleshoot CPU usage? My
network admin asked me to look at one of the servers: it seems after our
weekly restarts, the CPU usage keeps rising. What can I begin to look at to
determine what is causing this?Rich,
Start with Task Manager to determine what app is causing the issue. If SQL
Server, then drill down using System Monitor and Profiler.
HTH
Jerry
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:B55F66D8-C41D-4C04-9BC6-87F176891311@.microsoft.com...
> Hello Group,
> what is a good starting point setting a trace to troubleshoot CPU usage?
> My
> network admin asked me to look at one of the servers: it seems after our
> weekly restarts, the CPU usage keeps rising. What can I begin to look at
> to
> determine what is causing this?
what is a good starting point setting a trace to troubleshoot CPU usage? My
network admin asked me to look at one of the servers: it seems after our
weekly restarts, the CPU usage keeps rising. What can I begin to look at to
determine what is causing this?Rich,
Start with Task Manager to determine what app is causing the issue. If SQL
Server, then drill down using System Monitor and Profiler.
HTH
Jerry
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:B55F66D8-C41D-4C04-9BC6-87F176891311@.microsoft.com...
> Hello Group,
> what is a good starting point setting a trace to troubleshoot CPU usage?
> My
> network admin asked me to look at one of the servers: it seems after our
> weekly restarts, the CPU usage keeps rising. What can I begin to look at
> to
> determine what is causing this?
Subscribe to:
Posts (Atom)