Viewing 15 posts - 4,756 through 4,770 (of 7,496 total)
that's probably the best way to be sure your configuration meets at least your initial goals.
And as always, if it doesn't make sence for you, check your preception to the...
June 25, 2008 at 7:22 am
AndyD (6/24/2008)
I think this is normal operation for a Database Mirror without Witness. Have a read of "Forced Service (with Possible Data Loss)" in BOL. When the old Principal (instance01)...
June 25, 2008 at 7:16 am
Mike Levan (6/24/2008)
Hey may be this way i can tune my query but how could i do a group by on all my sleect statements if i split.
just as easy...
the...
June 25, 2008 at 5:41 am
then TornPageDetection is not enabled
I suggest you enable it or have it enabled as soon as you performed a checkdb and address all issues that may appear.
June 25, 2008 at 4:10 am
use sp_helpdb !
e.g.
exec sp_helpdb 'DDBAStatistics'
result:
status (added linefeeds to narrow the linesize)
-------------------------------
Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER,
Recovery=FULL, Version=611, Collation=SQL_Latin1_General_CP1_CI_AS,
SQLSortOrder=52, IsTornPageDetectionEnabled, IsAutoCreateStatistics,
IsAutoUpdateStatistics
If you find IsTornPageDetectionEnabled then it's ok.
June 25, 2008 at 3:40 am
You'll have to test it if suites your purpose because it is language dependant !
declare @tmptest table (idnr int not null identity(1,1) primary key, LName varchar(50) not null )
insert into...
June 24, 2008 at 12:24 pm
did you try to split the "UNION ALL"
So to rewrite the full query using the TT table
and then perform a union all using the full query with the ArchTT...
June 24, 2008 at 12:22 pm
Does the database have "torn page detection" ON ?
I would start with a dbcc checkdb !
June 24, 2008 at 12:14 pm
I'd suggest to make the primary key NONclustered !
Choose a clustered index that suites your usage ! and is as narrow as possible, preferable unique.
Keep in mind the clustered...
June 24, 2008 at 12:10 pm
... schedule jobs ... ??
- Predefined jobs ?
- their own jobs or also jobs of other users ,
- what to the jobs do ?
* exec a sproc
...
June 24, 2008 at 5:13 am
This LUN extend capabilities may depend on the kind of san you have.
HP xyz ?
June 24, 2008 at 3:35 am
A "strange" consideration.
In my test without a witness, but synchronized, it I simulated a principal failure (by shutting down its instance (instance01) ), I needed to perform
a Alter...
June 24, 2008 at 2:14 am
If - as you say - you suspect the mp:
- inspect the mp logging files (activate if needed)
- start a profiler trace right befor the mp is scheduled to launch.
-...
June 23, 2008 at 12:51 am
did you check the post sp4 hotfixes ? http://support.microsoft.com/kb/894905
June 20, 2008 at 4:57 am
what version of sql2000 are you running ?
(+ sp / hf)
June 20, 2008 at 4:04 am
Viewing 15 posts - 4,756 through 4,770 (of 7,496 total)