Tuesday, March 20, 2012
big problem with sql server 2000 msde sp 4 (stops working by accident)
I get the following error-message from sqlserver 2000 (msde edition)
I have no idea what is going wrong.
I was only able to get back to working state by
DBCC CHECKDB ALLOW-DATA-LOSS
(or restoring a backup)
But i do not want the db to crash at my customers ...
In the knowledge-base I found:
"An assertion or Msg 7987 may occur when an operation is performed on an
instance of SQL Server"
without any reason why inconsitencies can occur
This bug is at least known since 5th april 2005 ... and still known for
sql-server 9 (2005 I think)
I hope I oversaw something ... or does SQLServer realy stops to work by
chance?
please help!
2006-07-26 03:43:04.00 spid51 ex_raise2: Exception raised, major=79,
minor=87, severity=22, attempting to create symptom dump
2006-07-26 03:43:04.28 spid51 Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 51, PSS = 0x414491a8, EC = 0x414494d8
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 7/26/2006
Time: 5:32:26 AM
User: N/A
Computer: HLX02
Description:
Error: 7987, Severity: 22, State: 3
A possible database consistency problem has been detected on database
'faroer'. DBCC CHECKDB and DBCC CHECKCATALOG should be run on database
'faroer'.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 33 1f 00 00 16 00 00 00 3......
0008: 06 00 00 00 48 00 4c 00 ...H.L.
0010: 58 00 30 00 32 00 00 00 X.0.2...
0018: 07 00 00 00 66 00 61 00 ...f.a.
0020: 72 00 6f 00 65 00 72 00 r.o.e.r.
0028: 00 00 ..Sascha Bohnenkamp wrote:
> Hi,
> I get the following error-message from sqlserver 2000 (msde edition)
> I have no idea what is going wrong.
> I was only able to get back to working state by
> DBCC CHECKDB ALLOW-DATA-LOSS
> (or restoring a backup)
> But i do not want the db to crash at my customers ...
> In the knowledge-base I found:
> "An assertion or Msg 7987 may occur when an operation is performed on an
> instance of SQL Server"
> without any reason why inconsitencies can occur
> This bug is at least known since 5th april 2005 ... and still known for
> sql-server 9 (2005 I think)
> I hope I oversaw something ... or does SQLServer realy stops to work by
> chance?
> please help!
> 2006-07-26 03:43:04.00 spid51 ex_raise2: Exception raised, major=79,
> minor=87, severity=22, attempting to create symptom dump
> 2006-07-26 03:43:04.28 spid51 Using 'dbghelp.dll' version '4.0.5'
> *Dump thread - spid = 51, PSS = 0x414491a8, EC = 0x414494d8
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 7/26/2006
> Time: 5:32:26 AM
> User: N/A
> Computer: HLX02
> Description:
> Error: 7987, Severity: 22, State: 3
> A possible database consistency problem has been detected on database
> 'faroer'. DBCC CHECKDB and DBCC CHECKCATALOG should be run on database
> 'faroer'.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 33 1f 00 00 16 00 00 00 3......
> 0008: 06 00 00 00 48 00 4c 00 ...H.L.
> 0010: 58 00 30 00 32 00 00 00 X.0.2...
> 0018: 07 00 00 00 66 00 61 00 ...f.a.
> 0020: 72 00 6f 00 65 00 72 00 r.o.e.r.
> 0028: 00 00 ..
No, SQL Server does not "stop working by accident". Most likely you
have flaky hardware that is causing corruption in your database file.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben schrieb:
> No, SQL Server does not "stop working by accident". Most likely you
> have flaky hardware that is causing corruption in your database file.
well ... are there any chance to find someting to help find the problem
in the log files of the server (or in the dumps) ?
From teh stack dump I cannot see any i/o problems ...
* Short Stack Dump
* 009BA08C Module(sqlservr+005BA08C) (GetOSErrString+00004F68)
* 009BA9B5 Module(sqlservr+005BA9B5) (GetOSErrString+00005891)
* 006EE757 Module(sqlservr+002EE757) (SQLExit+00186C60)
* 005FA686 Module(sqlservr+001FA686) (SQLExit+00092B8F)
* 006BA785 Module(sqlservr+002BA785) (SQLExit+00152C8E)
* 004040DA Module(sqlservr+000040DA)
* 0042ADAE Module(sqlservr+0002ADAE)
* 0042A3D3 Module(sqlservr+0002A3D3)
* 0043638B Module(sqlservr+0003638B)
* 0043288B Module(sqlservr+0003288B)
* 00432542 Module(sqlservr+00032542)
* 00434980 Module(sqlservr+00034980)
* 00432542 Module(sqlservr+00032542)
* 00434980 Module(sqlservr+00034980)
* 00432542 Module(sqlservr+00032542)
* 00861732 Module(sqlservr+00461732) (GetIMallocForMsxml+0006CBB2)
* 0086116B Module(sqlservr+0046116B) (GetIMallocForMsxml+0006C5EB)
* 00434980 Module(sqlservr+00034980)
* 00432542 Module(sqlservr+00032542)
* 005B810A Module(sqlservr+001B810A) (SQLExit+00050613)
* 005B8266 Module(sqlservr+001B8266) (SQLExit+0005076F)
* 004398A5 Module(sqlservr+000398A5)
* 004398A5 Module(sqlservr+000398A5)
* 0041D396 Module(sqlservr+0001D396)
* 00861732 Module(sqlservr+00461732) (GetIMallocForMsxml+0006CBB2)
* 0086116B Module(sqlservr+0046116B) (GetIMallocForMsxml+0006C5EB)
* 005B810A Module(sqlservr+001B810A) (SQLExit+00050613)
* 005B8266 Module(sqlservr+001B8266) (SQLExit+0005076F)
* 00434980 Module(sqlservr+00034980)
* 00432542 Module(sqlservr+00032542)
* 004194B9 Module(sqlservr+000194B9)
* 004193E4 Module(sqlservr+000193E4)
* 00429EAA Module(sqlservr+00029EAA)
* 00415D04 Module(sqlservr+00015D04)
* 00416214 Module(sqlservr+00016214)
* 00415F28 Module(sqlservr+00015F28)
* 0076C7D0 Module(sqlservr+0036C7D0) (SQLExit+00204CD9)
* 007704EF Module(sqlservr+003704EF) (SQLExit+002089F8)
* 0077099C Module(sqlservr+0037099C) (SQLExit+00208EA5)
* 006332EC Module(sqlservr+002332EC) (SQLExit+000CB7F5)
* 0043D005 Module(sqlservr+0003D005)
* 0042598D Module(sqlservr+0002598D)
* 41075309 Module(ums+00005309) (UmsThreadScheduler::ExitUser+00000459)|||Sascha Bohnenkamp wrote:
> Tracy McKibben schrieb:
>> No, SQL Server does not "stop working by accident". Most likely you
>> have flaky hardware that is causing corruption in your database file.
> well ... are there any chance to find someting to help find the problem
> in the log files of the server (or in the dumps) ?
> From teh stack dump I cannot see any i/o problems ...
> * Short Stack Dump
> * 009BA08C Module(sqlservr+005BA08C) (GetOSErrString+00004F68)
> * 009BA9B5 Module(sqlservr+005BA9B5) (GetOSErrString+00005891)
> * 006EE757 Module(sqlservr+002EE757) (SQLExit+00186C60)
> * 005FA686 Module(sqlservr+001FA686) (SQLExit+00092B8F)
> * 006BA785 Module(sqlservr+002BA785) (SQLExit+00152C8E)
> * 004040DA Module(sqlservr+000040DA)
> * 0042ADAE Module(sqlservr+0002ADAE)
> * 0042A3D3 Module(sqlservr+0002A3D3)
> * 0043638B Module(sqlservr+0003638B)
> * 0043288B Module(sqlservr+0003288B)
> * 00432542 Module(sqlservr+00032542)
> * 00434980 Module(sqlservr+00034980)
> * 00432542 Module(sqlservr+00032542)
> * 00434980 Module(sqlservr+00034980)
> * 00432542 Module(sqlservr+00032542)
> * 00861732 Module(sqlservr+00461732) (GetIMallocForMsxml+0006CBB2)
> * 0086116B Module(sqlservr+0046116B) (GetIMallocForMsxml+0006C5EB)
> * 00434980 Module(sqlservr+00034980)
> * 00432542 Module(sqlservr+00032542)
> * 005B810A Module(sqlservr+001B810A) (SQLExit+00050613)
> * 005B8266 Module(sqlservr+001B8266) (SQLExit+0005076F)
> * 004398A5 Module(sqlservr+000398A5)
> * 004398A5 Module(sqlservr+000398A5)
> * 0041D396 Module(sqlservr+0001D396)
> * 00861732 Module(sqlservr+00461732) (GetIMallocForMsxml+0006CBB2)
> * 0086116B Module(sqlservr+0046116B) (GetIMallocForMsxml+0006C5EB)
> * 005B810A Module(sqlservr+001B810A) (SQLExit+00050613)
> * 005B8266 Module(sqlservr+001B8266) (SQLExit+0005076F)
> * 00434980 Module(sqlservr+00034980)
> * 00432542 Module(sqlservr+00032542)
> * 004194B9 Module(sqlservr+000194B9)
> * 004193E4 Module(sqlservr+000193E4)
> * 00429EAA Module(sqlservr+00029EAA)
> * 00415D04 Module(sqlservr+00015D04)
> * 00416214 Module(sqlservr+00016214)
> * 00415F28 Module(sqlservr+00015F28)
> * 0076C7D0 Module(sqlservr+0036C7D0) (SQLExit+00204CD9)
> * 007704EF Module(sqlservr+003704EF) (SQLExit+002089F8)
> * 0077099C Module(sqlservr+0037099C) (SQLExit+00208EA5)
> * 006332EC Module(sqlservr+002332EC) (SQLExit+000CB7F5)
> * 0043D005 Module(sqlservr+0003D005)
> * 0042598D Module(sqlservr+0002598D)
> * 41075309 Module(ums+00005309) (UmsThreadScheduler::ExitUser+00000459)
Doesn't have to be an I/O problem - it could be bad RAM, a bad CPU, any
number of things. You should run some hardware diagnostics on the
machine, perhaps even open an incident with Microsoft - they can help
you decipher the logs.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Monday, March 19, 2012
Big inconsistency!
Hi,
i have a sqlserver 2005 mergereplication.
some facts:
SQL Server 2005 9.0.3175 Standard Edition german1 Distributor / Publisher (same Server)
10 Subscriber
30 GB Database with 200 Tables ; in sum 35,000,000 rows
Every subscriber can change data.
Sometimes (i think in 1 of 1000 cases) following curious error occured:
the subscriber update data (for example varchar value), but the changes aren′t replicated to the publisher.
In case of our 35Mil rows, this is not acceptable.
What can I do? I have no specified error, no errormessage, but the data isn′t correct.
There is big inconsistency!!!
Any assistance gratefully received,
Best Regards
Thorsten Ueberschaer
1. can you reproduce the problem? i.e. can you make a change to a subscriber and for the change NOT to appear on the Publisher and/or other subscribers within reasonable time [with network connectivity, and several runs of the Distribution Agents] ?2. is this a permissions problem? obviously the DA's need access rights to be able to replay changes elsewhere.
3. have all subscribers been initialised ? should all start with same data [otherwise an UPDATE will fail later if there is no matching PK]
4. have you got sensible identities ? for INSERTs you should review the identity settings
sp_addmergearticle
[ , [ @.vertical_partition = ] 'vertical_partition' ]
[ , [ @.auto_identity_range = ] 'auto_identity_range' ]
[ , [ @.pub_identity_range = ] pub_identity_range ]
[ , [ @.identity_range = ] identity_range ]
[ , [ @.subscriber_upload_options = ] subscriber_upload_options ]
[ , [ @.identityrangemanagementoption = ] 'identityrangemanagementoption' ]
and do you have "NOT FOR REPLICATION" to prevent frictions ?
5. what collision resolver are you using? - perhaps a merge collision is being lost by resolver
- suggest more logging [e.g. change agent profile to verbose]
HTH
Dick
|||hello
1. no i can′t reproduce the problem.....
2. the replicationagents work in sysadmin-mode, in my opinion is this not a permission problem
3. yes, all subscribers have been initialised with the same data
4. all tables have uniqueidentifier-pk and -rowguid column, all fk′s are "not for replication"
5. 195 of our tables solve the collision with the standard collision resolver, 5 with "later wins", but i think, that is not a conflict problem, because, after a conflict all subscriber must have the same date (the winner or the loser)
any idea?
thanks
thorsten ueberschaer
|||Find a row that has not replicated. Pick off the value in the rowguid column. Search the MSmerge_contents table and see if a row exists for this rowguid value. That's step #1. If it isn't logged into MSmerge_contents by the triggers, it is never going to replicate.
|||hi
this was my first idea
but in msmerge_contents a row exists for my rowguid value
bye
|||What is the generation value? Have you tried to validate your subscriptions? What is the max generation that exists on the publisher and the subscriber in question?
|||the generationvalue is 218016
the maxgeneration on publisher is 4647424 and on subscriber is 4049693
i don′t understand my problem
sometimes it works, sometimes not
no exception, no error
it′s not reproduceable
i don′t like it :-(
|||If it happens more than once, it is reproducible somehow. It's a matter of figuring out the exact combination of actions that causes it. No, they aren't always straightforward. Tracking some of these things down can take weeks or months to isolate the problem. I have 6 open support cases dealing with issues in the merge metadata, the newest one has been open for over 2 weeks and while we can see the bad entries and know how to manually fix them, we still can't come up with a way to reproduce the problem. The oldest one I have on the books has been there for over 6 months and a repro still hasn't been isolated.
Then there is the one with subscribers mysteriously getting blown out which took over a month and a half before we finally figured out what the heck was happening and came up with an artificial way of reproducing it. Turns out that DNS was handing out the same IP address to more than one machine, from the perspective of SQL Server, but the DNS entry was not updated right away. This caused SQL Server to connect to MachineA which DNS resolved to an IP address which was actually MachineB thereby causing replication to think that everything was screwed up and to remove the subscription information. Try reliably reproducing something like that which only creates itself under some very specific VPN connection cicumstances which have to occur within a specific time sequence, between cycles of the merge engine.
Now that you have the generation number. Take a look in MSmerge_genhistory on the publisher and subscriber and see if an entry for this generation exists.
|||i have this problem sinc april :-(
i took a look in msmerge_genhistory, and the result is strange:
on publisher: the data is correct, there is a row
on the subscriber which generate the update: the data is also correct
on next subscriber, the data isn′t correct, there is no entry in msmerge_genhistory
|||I'm sorry, can't help with April. If you have this issue going back 6 months, that makes it extraordinarily difficult to try and track it down. If there isn't a row in MSmerge_genhistory for that generation, it means that the merge engine did not see it as a change to be propagated for some reason and therefore the change did not move. Again, I don't know why it would do that and it isn't going to be easy to find, because you have 6 months worth of change in this environment that the answer is buried within.
Have you ever run validation? If so, what were the results?
Big inconsistency!
Hi,
i have a sqlserver 2005 mergereplication.
some facts:
SQL Server 2005 9.0.3175 Standard Edition german1 Distributor / Publisher (same Server)
10 Subscriber
30 GB Database with 200 Tables ; in sum 35,000,000 rows
Every subscriber can change data.
Sometimes (i think in 1 of 1000 cases) following curious error occured:
the subscriber update data (for example varchar value), but the changes aren′t replicated to the publisher.
In case of our 35Mil rows, this is not acceptable.
What can I do? I have no specified error, no errormessage, but the data isn′t correct.
There is big inconsistency!!!
Any assistance gratefully received,
Best Regards
Thorsten Ueberschaer
1. can you reproduce the problem? i.e. can you make a change to a subscriber and for the change NOT to appear on the Publisher and/or other subscribers within reasonable time [with network connectivity, and several runs of the Distribution Agents] ?2. is this a permissions problem? obviously the DA's need access rights to be able to replay changes elsewhere.
3. have all subscribers been initialised ? should all start with same data [otherwise an UPDATE will fail later if there is no matching PK]
4. have you got sensible identities ? for INSERTs you should review the identity settings
sp_addmergearticle
[ , [ @.vertical_partition = ] 'vertical_partition' ]
[ , [ @.auto_identity_range = ] 'auto_identity_range' ]
[ , [ @.pub_identity_range = ] pub_identity_range ]
[ , [ @.identity_range = ] identity_range ]
[ , [ @.subscriber_upload_options = ] subscriber_upload_options ]
[ , [ @.identityrangemanagementoption = ] 'identityrangemanagementoption' ]
and do you have "NOT FOR REPLICATION" to prevent frictions ?
5. what collision resolver are you using? - perhaps a merge collision is being lost by resolver
- suggest more logging [e.g. change agent profile to verbose]
HTH
Dick
|||hello
1. no i can′t reproduce the problem.....
2. the replicationagents work in sysadmin-mode, in my opinion is this not a permission problem
3. yes, all subscribers have been initialised with the same data
4. all tables have uniqueidentifier-pk and -rowguid column, all fk′s are "not for replication"
5. 195 of our tables solve the collision with the standard collision resolver, 5 with "later wins", but i think, that is not a conflict problem, because, after a conflict all subscriber must have the same date (the winner or the loser)
any idea?
thanks
thorsten ueberschaer
|||Find a row that has not replicated. Pick off the value in the rowguid column. Search the MSmerge_contents table and see if a row exists for this rowguid value. That's step #1. If it isn't logged into MSmerge_contents by the triggers, it is never going to replicate.
|||hi
this was my first idea
but in msmerge_contents a row exists for my rowguid value
bye
|||What is the generation value? Have you tried to validate your subscriptions? What is the max generation that exists on the publisher and the subscriber in question?
|||the generationvalue is 218016
the maxgeneration on publisher is 4647424 and on subscriber is 4049693
i don′t understand my problem
sometimes it works, sometimes not
no exception, no error
it′s not reproduceable
i don′t like it :-(
|||If it happens more than once, it is reproducible somehow. It's a matter of figuring out the exact combination of actions that causes it. No, they aren't always straightforward. Tracking some of these things down can take weeks or months to isolate the problem. I have 6 open support cases dealing with issues in the merge metadata, the newest one has been open for over 2 weeks and while we can see the bad entries and know how to manually fix them, we still can't come up with a way to reproduce the problem. The oldest one I have on the books has been there for over 6 months and a repro still hasn't been isolated.
Then there is the one with subscribers mysteriously getting blown out which took over a month and a half before we finally figured out what the heck was happening and came up with an artificial way of reproducing it. Turns out that DNS was handing out the same IP address to more than one machine, from the perspective of SQL Server, but the DNS entry was not updated right away. This caused SQL Server to connect to MachineA which DNS resolved to an IP address which was actually MachineB thereby causing replication to think that everything was screwed up and to remove the subscription information. Try reliably reproducing something like that which only creates itself under some very specific VPN connection cicumstances which have to occur within a specific time sequence, between cycles of the merge engine.
Now that you have the generation number. Take a look in MSmerge_genhistory on the publisher and subscriber and see if an entry for this generation exists.
|||i have this problem sinc april :-(
i took a look in msmerge_genhistory, and the result is strange:
on publisher: the data is correct, there is a row
on the subscriber which generate the update: the data is also correct
on next subscriber, the data isn′t correct, there is no entry in msmerge_genhistory
|||I'm sorry, can't help with April. If you have this issue going back 6 months, that makes it extraordinarily difficult to try and track it down. If there isn't a row in MSmerge_genhistory for that generation, it means that the merge engine did not see it as a change to be propagated for some reason and therefore the change did not move. Again, I don't know why it would do that and it isn't going to be easy to find, because you have 6 months worth of change in this environment that the answer is buried within.
Have you ever run validation? If so, what were the results?
BIDS and SSMS very slow on Windows XP SP2
Hi,
opening SQL Server Management Studio 2005 or Business Intelligence Development Studio 2005 on my Windows XP SP2 Professional Edition is extremely slow. Espacially in BIDS it take several seconds for each action.
Is anybody aware of this problem? We didn't have those problems on Win2000 so I guess it is XP related.
Any ideas?
Regards
Norbert Bender
http://www.sql-server-performance.com//faq/?f=144|||I added the /nosplash option but it didn't change anything. It is still very slow. Any other idea?
Regards
Norbert
|||I would guess sometimes it take forever, when I had that problem I've uninstalled and resinstalled the tools which gave me senisble performance on that aspect.
|||I would start by making sure you have sufficient memory on the machine. Both SSMS and BIDS have a large number of .NET managed code components. .NET applications use quite a bit of memory, so they are much more performant on machines with lots of memory. SSMS runs fine on my 1.2 GHz P3 laptop, but it has 1GB of RAM.
Next, if you are running SSMS on the same machine as SQL Server, and if this is a development environment, I would limit the amount of RAM available to SQL Server. By default, SQL Server will use every available byte of memory on the machine if it thinks it needs it. This is a good thing for production servers where server performance is everything, but this tends to starve other applications running on the server. On my laptop, I limit the server to 128 MB of RAM, which is sufficient for testing purposes. If you are working with a production server, consider running SSMS or BIDS on a different machine and connecting remotely to the server.
Next, consider what else you are running in the background. If you are running a large number of applications, you might not have a lot of memory left for SSMS or BIDS. If you are running some application that is using the disk drive continuously, that can hurt performance too. The file system runs at very high priority and can monopolize the system if there are lot of reads and writes going on, particularly on single processor machines. My laptop becomes basically unusable while I'm compiling a large code-base, for example.
Last, if possible, make sure your machine can connect to the internet. The .NET runtime validates that the certificates that code is signed with are valid when applications start. Part of this operation requires the runtime to get the list of revoked certificates from the http://crl.microsoft.com website to make sure the code wasn't signed with a revoked certificate. (Some fake certificates were issued in Microsoft's name a few years back, so this is a real concern.) If the runtime can't quickly connect to the website, it can take up to 45 seconds for the operation to time-out completely. You can turn this check off, but it's fairly dangerous to do that on machines that are sometimes connected to the internet.
Hope this helps,
Steve
Thanks for those detailed information. I guess the last issue is it, as the account I am using is not the one, which is allowed to connect to the internet.
I will try this and I will give you feedback asap.
Regards nad thanks
Norbert
|||Thanks for the hints. I checked the permissions for the account and they can access the internet, so I guess, this isn't the solution. My client has has 1 GB to as RAM and ususally I do not have memory intensive apps running. I think I will reinstall the whole software maybe this helps
Regards
Norbert
BIDS and SSMS very slow on Windows XP SP2
Hi,
opening SQL Server Management Studio 2005 or Business Intelligence Development Studio 2005 on my Windows XP SP2 Professional Edition is extremely slow. Espacially in BIDS it take several seconds for each action.
Is anybody aware of this problem? We didn't have those problems on Win2000 so I guess it is XP related.
Any ideas?
Regards
Norbert Bender
http://www.sql-server-performance.com//faq/?f=144|||I added the /nosplash option but it didn't change anything. It is still very slow. Any other idea?
Regards
Norbert
|||I would guess sometimes it take forever, when I had that problem I've uninstalled and resinstalled the tools which gave me senisble performance on that aspect.
|||I would start by making sure you have sufficient memory on the machine. Both SSMS and BIDS have a large number of .NET managed code components. .NET applications use quite a bit of memory, so they are much more performant on machines with lots of memory. SSMS runs fine on my 1.2 GHz P3 laptop, but it has 1GB of RAM.
Next, if you are running SSMS on the same machine as SQL Server, and if this is a development environment, I would limit the amount of RAM available to SQL Server. By default, SQL Server will use every available byte of memory on the machine if it thinks it needs it. This is a good thing for production servers where server performance is everything, but this tends to starve other applications running on the server. On my laptop, I limit the server to 128 MB of RAM, which is sufficient for testing purposes. If you are working with a production server, consider running SSMS or BIDS on a different machine and connecting remotely to the server.
Next, consider what else you are running in the background. If you are running a large number of applications, you might not have a lot of memory left for SSMS or BIDS. If you are running some application that is using the disk drive continuously, that can hurt performance too. The file system runs at very high priority and can monopolize the system if there are lot of reads and writes going on, particularly on single processor machines. My laptop becomes basically unusable while I'm compiling a large code-base, for example.
Last, if possible, make sure your machine can connect to the internet. The .NET runtime validates that the certificates that code is signed with are valid when applications start. Part of this operation requires the runtime to get the list of revoked certificates from the http://crl.microsoft.com website to make sure the code wasn't signed with a revoked certificate. (Some fake certificates were issued in Microsoft's name a few years back, so this is a real concern.) If the runtime can't quickly connect to the website, it can take up to 45 seconds for the operation to time-out completely. You can turn this check off, but it's fairly dangerous to do that on machines that are sometimes connected to the internet.
Hope this helps,
Steve
Thanks for those detailed information. I guess the last issue is it, as the account I am using is not the one, which is allowed to connect to the internet.
I will try this and I will give you feedback asap.
Regards nad thanks
Norbert
|||Thanks for the hints. I checked the permissions for the account and they can access the internet, so I guess, this isn't the solution. My client has has 1 GB to as RAM and ususally I do not have memory intensive apps running. I think I will reinstall the whole software maybe this helps
Regards
Norbert
BIDS and SSMS very slow on Windows XP SP2
Hi,
opening SQL Server Management Studio 2005 or Business Intelligence Development Studio 2005 on my Windows XP SP2 Professional Edition is extremely slow. Espacially in BIDS it take several seconds for each action.
Is anybody aware of this problem? We didn't have those problems on Win2000 so I guess it is XP related.
Any ideas?
Regards
Norbert Bender
http://www.sql-server-performance.com//faq/?f=144|||I added the /nosplash option but it didn't change anything. It is still very slow. Any other idea?
Regards
Norbert
|||I would guess sometimes it take forever, when I had that problem I've uninstalled and resinstalled the tools which gave me senisble performance on that aspect.
|||I would start by making sure you have sufficient memory on the machine. Both SSMS and BIDS have a large number of .NET managed code components. .NET applications use quite a bit of memory, so they are much more performant on machines with lots of memory. SSMS runs fine on my 1.2 GHz P3 laptop, but it has 1GB of RAM.
Next, if you are running SSMS on the same machine as SQL Server, and if this is a development environment, I would limit the amount of RAM available to SQL Server. By default, SQL Server will use every available byte of memory on the machine if it thinks it needs it. This is a good thing for production servers where server performance is everything, but this tends to starve other applications running on the server. On my laptop, I limit the server to 128 MB of RAM, which is sufficient for testing purposes. If you are working with a production server, consider running SSMS or BIDS on a different machine and connecting remotely to the server.
Next, consider what else you are running in the background. If you are running a large number of applications, you might not have a lot of memory left for SSMS or BIDS. If you are running some application that is using the disk drive continuously, that can hurt performance too. The file system runs at very high priority and can monopolize the system if there are lot of reads and writes going on, particularly on single processor machines. My laptop becomes basically unusable while I'm compiling a large code-base, for example.
Last, if possible, make sure your machine can connect to the internet. The .NET runtime validates that the certificates that code is signed with are valid when applications start. Part of this operation requires the runtime to get the list of revoked certificates from the http://crl.microsoft.com website to make sure the code wasn't signed with a revoked certificate. (Some fake certificates were issued in Microsoft's name a few years back, so this is a real concern.) If the runtime can't quickly connect to the website, it can take up to 45 seconds for the operation to time-out completely. You can turn this check off, but it's fairly dangerous to do that on machines that are sometimes connected to the internet.
Hope this helps,
Steve
Thanks for those detailed information. I guess the last issue is it, as the account I am using is not the one, which is allowed to connect to the internet.
I will try this and I will give you feedback asap.
Regards nad thanks
Norbert
|||Thanks for the hints. I checked the permissions for the account and they can access the internet, so I guess, this isn't the solution. My client has has 1 GB to as RAM and ususally I do not have memory intensive apps running. I think I will reinstall the whole software maybe this helps
Regards
Norbert
Thursday, March 8, 2012
BI on Windows XP
Intelligence Project (Report Server Project) in Windows XP.
Which SQL Edition I can install in windows XP that gives me facility to
create report via Business Intelligence.
ThanksFirst, keep in mind that you are installing the BI Tools, you are not
installing SQL Server, you are not installing Reporting Services. Those are
server based and while they can be installed on XP (I know developers
edition, not sure what other editions) they are not needed for development.
The BI Tools are the same as far as I know for all editions. You can preview
the report, design the report. It is not until you are ready to deploy the
report to a server that RS even has to be installed somewhere.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rogers" <naissani@.hotmail.com> wrote in message
news:%23M9tGuWFIHA.3360@.TK2MSFTNGP04.phx.gbl...
>I want to create report through Microsoft Visual Studio 2005 (Business
>Intelligence Project (Report Server Project) in Windows XP.
> Which SQL Edition I can install in windows XP that gives me facility to
> create report via Business Intelligence.
> Thanks
>|||Alright, that means when I installed SQL Server 2005 Developer Edition on
XP, the BI will also be installed?
Thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:u4wyxqXFIHA.3980@.TK2MSFTNGP03.phx.gbl...
> First, keep in mind that you are installing the BI Tools, you are not
> installing SQL Server, you are not installing Reporting Services. Those
> are server based and while they can be installed on XP (I know developers
> edition, not sure what other editions) they are not needed for
> development. The BI Tools are the same as far as I know for all editions.
> You can preview the report, design the report. It is not until you are
> ready to deploy the report to a server that RS even has to be installed
> somewhere.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rogers" <naissani@.hotmail.com> wrote in message
> news:%23M9tGuWFIHA.3360@.TK2MSFTNGP04.phx.gbl...
>>I want to create report through Microsoft Visual Studio 2005 (Business
>>Intelligence Project (Report Server Project) in Windows XP.
>> Which SQL Edition I can install in windows XP that gives me facility to
>> create report via Business Intelligence.
>> Thanks
>>
>|||No, the install is a two step process. There is server side install which
includes reporting services (if you selected to install it) and then there
is installing client side tools. You have to do separate installs. Normally
the BI tools would not be on the server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rogers" <naissani@.hotmail.com> wrote in message
news:ugJQ2LKHIHA.6068@.TK2MSFTNGP05.phx.gbl...
> Alright, that means when I installed SQL Server 2005 Developer Edition on
> XP, the BI will also be installed?
> Thanks
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:u4wyxqXFIHA.3980@.TK2MSFTNGP03.phx.gbl...
>> First, keep in mind that you are installing the BI Tools, you are not
>> installing SQL Server, you are not installing Reporting Services. Those
>> are server based and while they can be installed on XP (I know developers
>> edition, not sure what other editions) they are not needed for
>> development. The BI Tools are the same as far as I know for all editions.
>> You can preview the report, design the report. It is not until you are
>> ready to deploy the report to a server that RS even has to be installed
>> somewhere.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rogers" <naissani@.hotmail.com> wrote in message
>> news:%23M9tGuWFIHA.3360@.TK2MSFTNGP04.phx.gbl...
>>I want to create report through Microsoft Visual Studio 2005 (Business
>>Intelligence Project (Report Server Project) in Windows XP.
>> Which SQL Edition I can install in windows XP that gives me facility to
>> create report via Business Intelligence.
>> Thanks
>>
>>
>
BI Development Studio Licensing and VS Express Edition
people using Visual Studio Express to develop reports?
I our shop we have two types of report developers, The first type is the
full blast developer that has the full Visual Studio product. The second
type does scripting and some light programming using the express products.
ThanksRS 2000 and RS 2005 are totally different in this respect. RS 2000 required
VS to install the designer into. RS 2005 will use VS if it is there but it
is not required. It will install its own copy if there is no VS. What this
means is that there is no dependency from either a physical or a licensing
perspective. VS is not needed for RS 2005 designer.
My guess is if VS Express is there it will install with it but that is just
a guess. As far as allowing, from a licensing perspecitve there is no
problem. Will it work, my guess is yes.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<hpux9@.nospam.nospam> wrote in message
news:26671BEE-78BA-4540-9B52-661A86BC65A6@.microsoft.com...
> If we have a fully functional and Licensed Report Server 2005, can we
> allow
> people using Visual Studio Express to develop reports?
> I our shop we have two types of report developers, The first type is the
> full blast developer that has the full Visual Studio product. The second
> type does scripting and some light programming using the express products.
> Thanks|||Bruce,
Thanks for the reply. I have installed RS 2005 designer on 2 workstations.
Workstation 1 has a licensed copy of VS2005, the install integrated with VS
2005 as expected.
The second PC had a copy of C# Express. On this box the install dropped
down a copy of VS that only had the BI project types (which is good!).
The only issue I see is that I had to enter the SQL 2005 license key (in
both cases) to get to the screen where I selected RS 2005 designer. If the
designer is trully "free" how am I going to get the software to the
developers?
Thanks!
"Bruce L-C [MVP]" wrote:
> RS 2000 and RS 2005 are totally different in this respect. RS 2000 required
> VS to install the designer into. RS 2005 will use VS if it is there but it
> is not required. It will install its own copy if there is no VS. What this
> means is that there is no dependency from either a physical or a licensing
> perspective. VS is not needed for RS 2005 designer.
> My guess is if VS Express is there it will install with it but that is just
> a guess. As far as allowing, from a licensing perspecitve there is no
> problem. Will it work, my guess is yes.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <hpux9@.nospam.nospam> wrote in message
> news:26671BEE-78BA-4540-9B52-661A86BC65A6@.microsoft.com...
> > If we have a fully functional and Licensed Report Server 2005, can we
> > allow
> > people using Visual Studio Express to develop reports?
> >
> > I our shop we have two types of report developers, The first type is the
> > full blast developer that has the full Visual Studio product. The second
> > type does scripting and some light programming using the express products.
> >
> > Thanks
>
>|||The install comes via the SQL Server 2005 CD, which requires a license key.
I don't see any way around this. You don't need additional server licenses
to install the design tool but you do need to be able to run the setup from
the CD.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<hpux9@.nospam.nospam> wrote in message
news:537D168E-4133-4D41-873A-204E89902F83@.microsoft.com...
> Bruce,
> Thanks for the reply. I have installed RS 2005 designer on 2
> workstations.
> Workstation 1 has a licensed copy of VS2005, the install integrated with
> VS
> 2005 as expected.
> The second PC had a copy of C# Express. On this box the install dropped
> down a copy of VS that only had the BI project types (which is good!).
> The only issue I see is that I had to enter the SQL 2005 license key (in
> both cases) to get to the screen where I selected RS 2005 designer. If
> the
> designer is trully "free" how am I going to get the software to the
> developers?
> Thanks!
> "Bruce L-C [MVP]" wrote:
>> RS 2000 and RS 2005 are totally different in this respect. RS 2000
>> required
>> VS to install the designer into. RS 2005 will use VS if it is there but
>> it
>> is not required. It will install its own copy if there is no VS. What
>> this
>> means is that there is no dependency from either a physical or a
>> licensing
>> perspective. VS is not needed for RS 2005 designer.
>> My guess is if VS Express is there it will install with it but that is
>> just
>> a guess. As far as allowing, from a licensing perspecitve there is no
>> problem. Will it work, my guess is yes.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <hpux9@.nospam.nospam> wrote in message
>> news:26671BEE-78BA-4540-9B52-661A86BC65A6@.microsoft.com...
>> > If we have a fully functional and Licensed Report Server 2005, can we
>> > allow
>> > people using Visual Studio Express to develop reports?
>> >
>> > I our shop we have two types of report developers, The first type is
>> > the
>> > full blast developer that has the full Visual Studio product. The
>> > second
>> > type does scripting and some light programming using the express
>> > products.
>> >
>> > Thanks
>>|||Bruce,
There are some features that you will not be able to use if you only
develop using BIDS though from what I have heard. What about custom code?
Custom assemblies? Is BIDS a fully functional replacement for developing
robust reports that need major customization (functions, code, assemblies)?
I need to know this. As far as I can see ... it will only install a BI
project type so where do you test custom code for example? I cant create a
custom assembly that is shared across all reports using BIDS alone. If I am
misunderstanding ... great. If I am not ... then I think it is important to
make sure people know that they will be losing function if they just go with
BIDS.
"Bruce L-C [MVP]" wrote:
> RS 2000 and RS 2005 are totally different in this respect. RS 2000 required
> VS to install the designer into. RS 2005 will use VS if it is there but it
> is not required. It will install its own copy if there is no VS. What this
> means is that there is no dependency from either a physical or a licensing
> perspective. VS is not needed for RS 2005 designer.
> My guess is if VS Express is there it will install with it but that is just
> a guess. As far as allowing, from a licensing perspecitve there is no
> problem. Will it work, my guess is yes.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <hpux9@.nospam.nospam> wrote in message
> news:26671BEE-78BA-4540-9B52-661A86BC65A6@.microsoft.com...
> > If we have a fully functional and Licensed Report Server 2005, can we
> > allow
> > people using Visual Studio Express to develop reports?
> >
> > I our shop we have two types of report developers, The first type is the
> > full blast developer that has the full Visual Studio product. The second
> > type does scripting and some light programming using the express products.
> >
> > Thanks
>
>|||BIDS is for designing reports. You can do code behind reports but you cannot
do custom assemblies. If you do that you need VB.Net (or C# etc). A whole
lot of people are desinging reports only. Previously it was a big hassle,
they would be installing VS just for the report designer. If they are doing
that then they would not be doing anything you are talking about.
I disagree they are losing functionality. RS 2000 had to have some product
installed that had VS to get the designer installed. The designer previously
did not give you the tools to do anything that you mentioned (create custom
assemblies for example). Obviously if you are creating your own web pages
then you need a designer to do so. If you are creating your own custom
assemblies ditto. However, most people are not doing that (creating custom
assemblies).
There are two markets. People who are tightly integrating into their own app
or are integrating in their own data extensions or authentication. I'd say
the vast majority are not doing that. The others are using Report Manager
portal as is.
Obviously you are not doing that. Your type of development is why VS 2005
has the new controls. Note these controls do not come with RS 2005, you have
to purchase VS 2005 to get these (or VB.Net 2005 etc). Just for the controls
anyone integrating with their own app should get VS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:94B2AA1F-AC25-4B6C-A29C-FD268445CA99@.microsoft.com...
> Bruce,
> There are some features that you will not be able to use if you only
> develop using BIDS though from what I have heard. What about custom code?
> Custom assemblies? Is BIDS a fully functional replacement for developing
> robust reports that need major customization (functions, code,
> assemblies)?
> I need to know this. As far as I can see ... it will only install a BI
> project type so where do you test custom code for example? I cant create
> a
> custom assembly that is shared across all reports using BIDS alone. If I
> am
> misunderstanding ... great. If I am not ... then I think it is important
> to
> make sure people know that they will be losing function if they just go
> with
> BIDS.
> "Bruce L-C [MVP]" wrote:
>> RS 2000 and RS 2005 are totally different in this respect. RS 2000
>> required
>> VS to install the designer into. RS 2005 will use VS if it is there but
>> it
>> is not required. It will install its own copy if there is no VS. What
>> this
>> means is that there is no dependency from either a physical or a
>> licensing
>> perspective. VS is not needed for RS 2005 designer.
>> My guess is if VS Express is there it will install with it but that is
>> just
>> a guess. As far as allowing, from a licensing perspecitve there is no
>> problem. Will it work, my guess is yes.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <hpux9@.nospam.nospam> wrote in message
>> news:26671BEE-78BA-4540-9B52-661A86BC65A6@.microsoft.com...
>> > If we have a fully functional and Licensed Report Server 2005, can we
>> > allow
>> > people using Visual Studio Express to develop reports?
>> >
>> > I our shop we have two types of report developers, The first type is
>> > the
>> > full blast developer that has the full Visual Studio product. The
>> > second
>> > type does scripting and some light programming using the express
>> > products.
>> >
>> > Thanks
>>
BI Application & SQL Server Express Edition
I was wondering whether anyone could enlighten me:
We currently build DB apps with a jet engine DB and c# Windows Form front end.
We wish to develop client windows form apps that can be installed on client PCs, which will have an SQL Server back-end and windows form Front End. However the apps we want to build are BI application using cubes we generate (in Analysis Services).
Now am I right in saying that we cannot develop an application that can be installed on a customer site that would include SQL Server Expres AND have the BI functionality? We wish to build a tool for customers that allows them to slice and dice data we provide
It is a pre-requisite that we must not assume that they have access to the internet and we cannot assume that they have an SQL Server which we could automatically install our product onto (to allow for BI functionailty).
So far all the tools we seen and the end-to-end applications, tend to refer to a pre-exisitng installation of SQL Server (with Analysis Services) e.g. Programmming SQL Server 2005 - Microsoft Press.
We need to create custom apps that can "stand alone". Is there any solution?
First. Analysis Services component of the Microsoft SQL Server 2005 product is not part of the Express Edition. It is part of any other edition of SQL Server ( except may be for the mobile edition )
This doesnt mean you cannot install Express and Standard editions of SQL Server side.
Now there is wide range of functionality supported by Analysis Services. You have to figure out what you would like to provide your users with.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Wednesday, March 7, 2012
Beyond 8 GB memory
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Sam Moayedi" <anonymous@.discussions.microsoft.com> wrote in message
news:CF7CA24D-D1FD-4C6F-A891-F9BBE6559DAC@.microsoft.com...
> We upgraded our server to Windows 2003 Ent edition and added extra 8 GB
memory to the machine, operating system sees all 16 GB also ent mgr
properties shows all 16 GB memory, I assigned 14 GB to SQL server but perf
monitor (total server memory) only shows 7GB memory, any reason for this?
BETWEEN LAPTOP AND DESKTOP
Hi,
I want to jumpstart my learning of SQL Server so I downloaded the Express edition onto my desktop in the office and also onto my laptop. I usually connect the two machines (through a LAN) to update whatever I was able to do at home while in the office.
What should I do in order to view or edit whatever I started on the laptop from the desktop? Would the databases I create on one be accessible through the other machine for editing and the likes?
Glint.
hi Glint,
you first need connectivity.. if that has to be performed at work, this is not a problem, as you just plug the office lan cable and you are on..
actually you do not need SQLExpress to be installed at all in the desktop pc as your "server" is located in the laptop.. so you just need to (remotely) connect from desktop (client) to the laptop (server)..
SQLExpress installs by default disabling network connections, so you need to run the Surface Area Configuration tool to enable "remote connections" and run SQL Server Configuration Manager to verify the desired network protocol is enabled..
you can then "connect" to your laptop server providing the appropriate credentials.. (by default SQLExpress installs allowing only WinNT authenticated connections, but you can modify that behaviour at "run time" to accept standard SQL Server authenticated connections (providing userid and password) modifying a Windows registry key,
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer
LoginMode = 2
where MSSQL.1 identifies your "engine number".. if you only installed 1 instance MSSQL.1 should be ok... or, you can download (recommended anyway) the SQL Server Management Studio Express, the "official" GUI based management tool for SQLExpress, from http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en, and connect via a trusted connection witl administrators permissions, select the server node, access it's properties and modify the "Server authentication" properties (Security tab) to "SQL Server and Windows Authentication mode"..
but this does not "copy or sync" your laptop "databases" to the office desktop.. if you need it to (copy), you have to "detach" the database you are interested wih, copy the relative physical files to the desktop, and attach the database there (see http://msdn2.microsoft.com/en-us/library/ms190794.aspx and http://msdn2.microsoft.com/en-us/library/ms187858.aspx for further info).. the very same task can be performed via a backup+restore action.. you backup a database (full backup) on the "server", copy the backup file to the destination machine, and restore there the database, http://msdn2.microsoft.com/zh-cn/library/9st0dc24.aspx
so you have the choice to "copy" your homework to the office pc, eventually work on it and finally re-copy all to the laptop for further homeworks, or just always connect to your laptop for office work as well..
please consider downloading Books On Line (BOL), the official and primary help resource for SQL Server at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx..
regards
|||Thanx, Andrea.BETWEEN LAPTOP AND DESKTOP
Hi,
I want to jumpstart my learning of SQL Server so I downloaded the Express edition onto my desktop in the office and also onto my laptop. I usually connect the two machines (through a LAN) to update whatever I was able to do at home while in the office.
What should I do in order to view or edit whatever I started on the laptop from the desktop? Would the databases I create on one be accessible through the other machine for editing and the likes?
Glint.
hi Glint,
you first need connectivity.. if that has to be performed at work, this is not a problem, as you just plug the office lan cable and you are on..
actually you do not need SQLExpress to be installed at all in the desktop pc as your "server" is located in the laptop.. so you just need to (remotely) connect from desktop (client) to the laptop (server)..
SQLExpress installs by default disabling network connections, so you need to run the Surface Area Configuration tool to enable "remote connections" and run SQL Server Configuration Manager to verify the desired network protocol is enabled..
you can then "connect" to your laptop server providing the appropriate credentials.. (by default SQLExpress installs allowing only WinNT authenticated connections, but you can modify that behaviour at "run time" to accept standard SQL Server authenticated connections (providing userid and password) modifying a Windows registry key,
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer
LoginMode = 2
where MSSQL.1 identifies your "engine number".. if you only installed 1 instance MSSQL.1 should be ok... or, you can download (recommended anyway) the SQL Server Management Studio Express, the "official" GUI based management tool for SQLExpress, from http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en, and connect via a trusted connection witl administrators permissions, select the server node, access it's properties and modify the "Server authentication" properties (Security tab) to "SQL Server and Windows Authentication mode"..
but this does not "copy or sync" your laptop "databases" to the office desktop.. if you need it to (copy), you have to "detach" the database you are interested wih, copy the relative physical files to the desktop, and attach the database there (see http://msdn2.microsoft.com/en-us/library/ms190794.aspx and http://msdn2.microsoft.com/en-us/library/ms187858.aspx for further info).. the very same task can be performed via a backup+restore action.. you backup a database (full backup) on the "server", copy the backup file to the destination machine, and restore there the database, http://msdn2.microsoft.com/zh-cn/library/9st0dc24.aspx
so you have the choice to "copy" your homework to the office pc, eventually work on it and finally re-copy all to the laptop for further homeworks, or just always connect to your laptop for office work as well..
please consider downloading Books On Line (BOL), the official and primary help resource for SQL Server at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx..
regards
|||Thanx, Andrea.Friday, February 24, 2012
Beta program for Laguna?
I'm interested in looking at SQL Server Mobile Edition (Laguna) and
wondered if there was a beta program for it, and the possibility of
getting on the program.
http://www.microsoft.com/sql/ce/productinfo/SQLMobile.asp
Thanks.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.htmlSorry, wrong newsgroup, please ignore.
Mark Allison wrote:
> Hi,
> I'm interested in looking at SQL Server Mobile Edition (Laguna) and
> wondered if there was a beta program for it, and the possibility of
> getting on the program.
> http://www.microsoft.com/sql/ce/productinfo/SQLMobile.asp
> Thanks.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
Best way to upgrade for SQLServer2000 standard to Enterprice
One of our customers need SQL to run on more than 2GB of memory. They are
running on SQL2000 standard edition and therefor need to upgrade to
Enterprice edition. Is it just to install then new CD's over the old system
or do we need to do it as a reinstall of the server and some backup/restore
of the database? Our customers talked about some wizards to do this. Any
"best practice" advice anyone?
Thanx
GeirGeir ,
it's really simple. Just run the setup select the option upgrade and if
necessary add some (new) components. It shouldn't take more tha 2
minutes and if I there's no need to reapply service packs.
But as always, make sure you have a backup of all your databases
including the system databases before you start.
Markus|||Hi
The amount of memory you can use also depends on the version of the OS you
are using, which you haven't specified.
If you haven't already check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
http://www.sql-server-performance.com/awe_memory.asp
http://support.microsoft.com/kb/274750
You should be able to install over your existing system, make sure that you
have backups of all your databases and a recovery plan for each stage in the
process, so that you know exactly how to get your system back up and running
in the event of problems being encountered.
John
"Geir Holme" wrote:
> Hi all.
> One of our customers need SQL to run on more than 2GB of memory. They are
> running on SQL2000 standard edition and therefor need to upgrade to
> Enterprice edition. Is it just to install then new CD's over the old system
> or do we need to do it as a reinstall of the server and some backup/restore
> of the database? Our customers talked about some wizards to do this. Any
> "best practice" advice anyone?
> Thanx
> Geir
>
>
Best way to upgrade for SQLServer2000 standard to Enterprice
One of our customers need SQL to run on more than 2GB of memory. They are
running on SQL2000 standard edition and therefor need to upgrade to
Enterprice edition. Is it just to install then new CD's over the old system
or do we need to do it as a reinstall of the server and some backup/restore
of the database? Our customers talked about some wizards to do this. Any
"best practice" advice anyone?
Thanx
GeirGeir ,
it's really simple. Just run the setup select the option upgrade and if
necessary add some (new) components. It shouldn't take more tha 2
minutes and if I there's no need to reapply service packs.
But as always, make sure you have a backup of all your databases
including the system databases before you start.
Markus|||Hi
The amount of memory you can use also depends on the version of the OS you
are using, which you haven't specified.
If you haven't already check out:
http://msdn.microsoft.com/library/d...br />
8dbn.asp
http://www.sql-server-performance.com/awe_memory.asp
http://support.microsoft.com/kb/274750
You should be able to install over your existing system, make sure that you
have backups of all your databases and a recovery plan for each stage in the
process, so that you know exactly how to get your system back up and running
in the event of problems being encountered.
John
"Geir Holme" wrote:
> Hi all.
> One of our customers need SQL to run on more than 2GB of memory. They are
> running on SQL2000 standard edition and therefor need to upgrade to
> Enterprice edition. Is it just to install then new CD's over the old syste
m
> or do we need to do it as a reinstall of the server and some backup/restor
e
> of the database? Our customers talked about some wizards to do this. Any
> "best practice" advice anyone?
> Thanx
> Geir
>
>|||Geir ,
it's really simple. Just run the setup select the option upgrade and if
necessary add some (new) components. It shouldn't take more tha 2
minutes and if I there's no need to reapply service packs.
But as always, make sure you have a backup of all your databases
including the system databases before you start.
Markus|||Hi
The amount of memory you can use also depends on the version of the OS you
are using, which you haven't specified.
If you haven't already check out:
http://msdn.microsoft.com/library/d...br />
8dbn.asp
http://www.sql-server-performance.com/awe_memory.asp
http://support.microsoft.com/kb/274750
You should be able to install over your existing system, make sure that you
have backups of all your databases and a recovery plan for each stage in the
process, so that you know exactly how to get your system back up and running
in the event of problems being encountered.
John
"Geir Holme" wrote:
> Hi all.
> One of our customers need SQL to run on more than 2GB of memory. They are
> running on SQL2000 standard edition and therefor need to upgrade to
> Enterprice edition. Is it just to install then new CD's over the old syste
m
> or do we need to do it as a reinstall of the server and some backup/restor
e
> of the database? Our customers talked about some wizards to do this. Any
> "best practice" advice anyone?
> Thanx
> Geir
>
>
Tuesday, February 14, 2012
Best way to implement "warm" standby? - considering log shipping
Log Shipping is the ultimate solution if you are on SQL
Server Enterprise Edition. Follow these Resources..
Log Shipping in SQL Server 2000 - Part 1
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
Log Shipping in SQL Server 2000 - Part 2
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
How to Perform SQL Server Log Shipping
http://www.sql-server-
performance.com/sql_server_log_shipping.asp
HTH
THIRUMAL REDDY MARAM
Sys Amin / SQL DBA
quote:
>--Original Message--
>I have TWO networked servers; one production, and one
backup. I want to be
quote:
>able to use the backup in case of a production server
failure. The loss of
quote:
>a "little" data is acceptable in case of failure. Log
Shipping looks like
quote:
>the easiest but there seems to be a lot of warnings about
(1) having a
quote:
>monitor server, and (2) having this server NOT be either
the production
quote:
>server nor the backup. I only have two servers so I
can't do this.
quote:
>Is Log Shipping the best solution? Also--and this might
affect your
quote:
>response--it is possible that the backup system might
not be available 100%
quote:
>of the time. I bring this up because I don't know what
will happen if the
quote:
>production system wants to ship a log, and the backup
computer isn't
quote:Thanks, Thirumal,
>available to accept it. (')
>Any help, recommendations?
>TIA,
>Larry Woods
>
>.
>
I've printed off all three articles and I will study them.
Larry
"Thirumal" <treddym@.hotmail.nospam.com> wrote in message
news:129a01c3df61$ab5c71d0$a601280a@.phx.gbl...[QUOTE]
> Hi Larry,
> Log Shipping is the ultimate solution if you are on SQL
> Server Enterprise Edition. Follow these Resources..
> Log Shipping in SQL Server 2000 - Part 1
> http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
> Log Shipping in SQL Server 2000 - Part 2
> http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/deploy/prodspecs/logship1.asp
> How to Perform SQL Server Log Shipping
> http://www.sql-server-
> performance.com/sql_server_log_shipping.asp
> HTH
> --
> THIRUMAL REDDY MARAM
> Sys Amin / SQL DBA
> backup. I want to be
> failure. The loss of
> Shipping looks like
> (1) having a
> the production
> can't do this.
> affect your
> not be available 100%
> will happen if the
> computer isn't