Viewing 15 posts - 43,921 through 43,935 (of 49,552 total)
How are you planning to load balance 2 SQL server databases? (Or have I misunderstood your question)
Clustering isn't for load-balancing. It's for high-availability.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 5:13 am
You can get SQL Server Developer for around $50. Search Microsoft's site, it's somewhere there. Developer has the full Enterprise features, it's just licensed only for development usage.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 4:55 am
There's no easy way in 2005. The counters that keep track of changes are hidden.
SQL will automatically update stats on a column as soon as the number of changes to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 3:43 am
That is a topic that gets endlessly debated. There's no right or wrong side, just preferences.
Myself, I don't like 'N/A' or 'unknown' records scattered all over my DB, so I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 3:42 am
gpet (10/9/2008)
Yes it is in Oracle 10g.Am I in a wrong forum?
Yes. This forum is dedicated to Microsoft's SQL Server.
May I suggest DBForums[/url] as they have an Oracle section.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 3:21 am
You'll probably have to call Microsoft's support people on this one. That kind of thign is usually an unhandled exception in the code and not something that we can fix.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 3:20 am
sqlservertica (10/8/2008)
The old server had 8 processors and the new server has 16, but remember that our new server is a 64bit machine and the old one was 32bit.
The main...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 3:12 am
Maybe, maybe not. It depends on how bad the corruption is. No way to tell without seeing the results of CheckTable or CheckDB.
In SQL 2000 I think it does take...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2008 at 2:47 pm
Is it a clustered server?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2008 at 2:39 pm
Yes, it will take time. Probably a couple of hours. You still need to do it.
At this point you have an unknown amount of corruption of unknown severity in that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2008 at 2:39 pm
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic582886-148-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2008 at 2:29 pm
Do you have any access to the database at all? If so, please run the following at regular intervals (every couple hours) and see which values are changing the fastest...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2008 at 2:28 pm
Direct attached storage, SAN, NAS, network drive?
Is is a clustered server? If so, is the E drive a dependency of SQL in the cluster admin?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2008 at 2:25 pm
None of the above. You've got database corruption. Please run the following and post the results.
DBCC CHECKDB(< Database Name > ) WITH NO_INFOMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2008 at 2:23 pm
How many processing cores did the old server have, how many does the new one have?
SQL Server's max memory setting. Configured under server properties (object explorer in management studio) or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2008 at 2:21 pm
Viewing 15 posts - 43,921 through 43,935 (of 49,552 total)