Showing posts with label onthe. Show all posts
Showing posts with label onthe. Show all posts

Friday, March 30, 2012

PROS and CONS of seperate databases for CACHING...

I have a main database...for this large Web site...and Im wonderingwhat would be the PROS and CONS of using another database (located onthe same, or on another SQL Server). Im just thinking this would begood incase we ever needed to take some load off one of the servers.

Also, we will be integrating Community Server into this Web site. Ofcourse you know CS adds its own database objects which crowd up ourmain database objects.

We were thinking of giving CS its own database also; bad practice, or...it doesn't matter much?

Thank youIf for ASPSTATE, then a separate server (now or in the future) would improve scalability.

If you mean multiple instances of SQL Server on the same server box (SQL Server 2000 and 2005 standard and up), then it is not a good idea as there is an overhead (plus licensing cost).

If you mean multiple databases within the same SQL instance, then that is the way to go.|||multiple databases within the same instance of sql server if its on the same machine...

sort of like this...

BOX1-SQL1 (all in same instance of sql server)
caching db
state db
auditing db

BOX2-SQL2 (all in same instance of sql server)
web site db
forum db

So THATS the way to go? Eh?
|||bumpsql

Wednesday, March 28, 2012

Properties window closes abruptly - Flashes on for a second only.

I have a SQL 2000 server, SP3a, on a Windows 2000 server, SP4. When I
try to access the properties window of the server, it just flashes on
the screen for a second, and closes. Other applications with
properties type windows work fine, so it appears to be SQL related.
Any ideas would be greatly appreciated.Hello,
Thanks for your post. According to your description I understand that when
you try to access the properties window of SQL Server, the dialog just
flashes on the screen for a second and closes. This behavior is strange and
I would like you to provide more information so that I can fully understand
the problem.
1. What is the properties window of the SQL Server? Do you mean the
property dialog of SQL Server in Enterprise Manager?
2. Does this problem occur randomly? Can you reproduce this behavior?
3. If so, please describe the reproduce steps in detail so that I can try
to reproduce this behavior on my side.
I am looking forward to hearing from you soon.
Best regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.