Viewing 15 posts - 5,056 through 5,070 (of 6,676 total)
homebrew01 (6/2/2009)
No open transactions now. DBCC SQLPERF(LOGSPACE) showed 4.5 Gig. I've shrunk it to 1.5 Gig which should be enough. I need to get more disk !
That was going to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 2, 2009 at 9:18 am
You also could have a long running open transaction that is keeping the log file from being re-used. Another thing to look at is whether or not log shipping,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 2, 2009 at 12:25 am
homebrew01 (6/1/2009)
"Database...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 1, 2009 at 11:59 pm
How many databases do you have on this instance?
How many of these databases are in full recovery model?
How often are you backing up the transaction log for each database that...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 1, 2009 at 8:25 pm
sql_lock (6/1/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 1, 2009 at 2:00 pm
What edition of SQL Server are you running? Standard or Enterprise?
What is the max memory setting for this instance?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 1, 2009 at 1:47 pm
Tracey, it looks like this server has 16GB of memory on it. Can you confirm?
If so, what else is installed and running on this server? Because, if you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 1, 2009 at 1:15 pm
I would very much doubt that this is a problem with the drivers being used to connect to the database. As far as those drivers are concerned, they have...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 1, 2009 at 12:30 pm
You don't want to use all processor for several reasons. One reason is that you have multiple queries all using parallel plans, the system is going to take longer...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 1, 2009 at 12:12 pm
Karin Zirk (6/1/2009)
Did you set the lock pages in memory option? - NO
Did you set the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 1, 2009 at 11:02 am
Cost Threshold for parellelism = 5
The above setting tells SQL Server that any plans that will exceed that value (estimated), then a parallel plan will be used.
Max Degree pf Parellelism...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 1, 2009 at 10:53 am
You have a dot in the extension (bak instead of .bak) - remove that and it will work.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 1, 2009 at 10:25 am
The first question to ask is why do you want to shrink the database? If this is a one time operation, then you really need to look at shrinkfile...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 31, 2009 at 9:52 am
SQL Server 2008 Express Edition is the freely available version from Microsoft. There is no trial period associated with that version.
SQL Server, including the express edition, is not registered...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 30, 2009 at 2:02 pm
Are you restoring from a file on the network? Or is the file local? The I/O system is usually what causes restore rates to be fast or slow...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 30, 2009 at 1:58 pm
Viewing 15 posts - 5,056 through 5,070 (of 6,676 total)