Viewing 15 posts - 2,401 through 2,415 (of 2,435 total)
Just to provide a couple of comparison times ...
HP-DL-580 quad 3.0 Gh Xeon CPU, RAID 1 OS, separate RAID 5 SAN arrays for data, log and backup. Restore time for...
January 28, 2005 at 6:53 am
I try to keep the total size of a transaction log to 10-20% of the total database data size for starters and hourly transaction log backups. Then based on log...
January 28, 2005 at 6:46 am
You don't mention whether the application is home-grown or a vendor supplied package ? If it's a vendor suplied package have you tried to contact their helpdesk line posing the...
January 28, 2005 at 6:26 am
If you have the extra cash (possibly 1-2 K), look into upgrading to SQL2K Enterprise from sStandard. Enterprise has built in log shipping functionality which sounds like a tailor made fit...
January 27, 2005 at 9:54 am
There may be 2 issues here. First I'd go back to BOL and check out everything I could on transaction logging. If recoverabilty is not an issue then 'Simple' is...
January 27, 2005 at 9:52 am
For logins check out this link: http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
January 27, 2005 at 9:45 am
You might want to look into the sysprocesses table ... there are a few columns present (if the application connection string populates them) that might make this a snap.
January 27, 2005 at 9:37 am
We have several vendor applications that issue similar messages for login failures (as opposed to' 42000 login failed', the norm). To diagnose these we've have to extract the user/password from...
January 26, 2005 at 11:26 am
As a part of a standard SQL server installation/configuration we always set the size and growth attributes of the master, msdb and tempdb databases. By doing this initially we've avoided...
January 26, 2005 at 11:17 am
5 platforms in all:
WIndows XP --> for the kids
NT 4.0 Server --> SCSI II, RAID 5, SQL v7.0, Sybase ASE v12, Oracle v8, old work box (soon to be Win 2K3...
January 23, 2005 at 5:45 pm
245 columns in one table ?!?!? Well maybe a shot a normalization (breaking things up into a few tables) just might be in order. Not attempting to do this might well be...
January 23, 2005 at 5:31 pm
I'd run perfmon on the pagefile, memory, and maybe processes before even thinking about changing anything.
January 21, 2005 at 12:03 pm
Just a few brief thoughts shooting from the hip:
1) is the MDAC up to date ?
2) up the memory to 256 Mb (256 Mb is plenty for windows with MSDE...
January 20, 2005 at 4:09 pm
Since this v6.5, the first 2 Mb of tempdb by default are on the master device. Based on how large you want to grow it you will have to add...
January 20, 2005 at 4:01 pm
If it's only 2 machines it does not sound like an issue. If you have SMS available that makes life much easier. Just create a package, advertise it and you're...
January 19, 2005 at 2:47 pm
Viewing 15 posts - 2,401 through 2,415 (of 2,435 total)