Viewing 15 posts - 61 through 75 (of 131 total)
Ever consider putting a full text index on it?
Consider adding an integer key to the table, all tables that have the join column......IE normalize the data. I have had systems increase...
February 21, 2007 at 1:07 pm
Ever use the sp_monitor procedure?
It shows CPU, and IO bottlenecks. While not true memory, keepign a running log of these values would show if your issues are with CPU or...
February 21, 2007 at 1:03 pm
Solved it as part of re-examining the issue.....double checking my tables...
Found the bad entry and removed the database from the Log_shipping_monitor_secondary table and the error went away.
Love it when...
February 21, 2007 at 12:56 pm
I just went thru all of my system tables in the MSDB database. There were several tables in there with old information that the SQL server didnt clean up.
February 21, 2007 at 12:50 pm
Well the roboot is good information. We will have to wait for a system re-start for that install.
And I am not doing anything with cleanup maintence plans....so I am...
February 21, 2007 at 12:25 pm
I have one server that always says the same thing....
The problem it is for an old test database that I deleted. SQL server was not smart enough to clean up...
February 21, 2007 at 12:23 pm
Have you tried doing a manual restore. We had to because our primary database was over 100 gig and being shipped a long distance.....was much quicker to backup/zip/ship/unzip/restore then setup...
February 21, 2007 at 9:23 am
one last thing....
To determine which one you have installed, click on the properties for your SQL Server instance, and look on the
GENERAL Page
>>>> Product : Microsoft SQL Server (Standard/Enterprise/Developer)...
February 21, 2007 at 8:11 am
IA64 is if you have an Itanium 64 bit Machine and SQL Server
x64 is if your running the normal 64 bit SQL Server
X86 is for all others ( normal 32...
February 21, 2007 at 8:04 am
Helen
I have an entire failover system for 25 separate clients setup using the 2005 log shipping. Has been in production for 6 months with no problems.
Are you looking for the...
February 21, 2007 at 7:51 am
When I upgraded...
used sp_help_revlogin for Logins, it worked great.
I did the database restore with the move option to setup the database and bring over the authorized users. I think that...
February 20, 2007 at 12:04 pm
If you break your job up and setup seperate steps for each part, you can query against each step for success for failure.
I run the following script against my production jobs to let me know...
February 20, 2007 at 9:52 am
I like a tool called IPMonitor8, it is powerful, inexpensice and my SAS 70 auditors loved it.
http://www.ipmonitor.com/default.aspx
it does a great job of monitoring my disk space, SQL Server,...
January 25, 2007 at 10:39 am
I use the following query to monitor the status of my nightly jobs....put it into a procedure....
Eric
select
distinct [name] as
January 25, 2007 at 10:29 am
Viewing 15 posts - 61 through 75 (of 131 total)