Viewing 15 posts - 44,761 through 44,775 (of 49,552 total)
It means that the OS has forced a lot of SQL's memory into the swap file. As the message says, it's near guranteed to result in poor performance.
How much memory...
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
August 31, 2008 at 11:39 pm
Is it enabled? (check the status tab of the login properties)
I don't have that on my system, but the couple of ## logins I do have are disabled.
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
August 31, 2008 at 2:09 pm
Something like this should work. It's rough, but should give you the idea.
CREATE TABLE #AllDbSpaceInfo (
...
)
exec sp_MSForEachDB ('Use ?; Insert into #AllDbSpaceInfo EXEC ....)
SELECT * from #AllDbSpaceInfo
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
August 31, 2008 at 1:19 pm
Restore a backup? Depending on the type of corruption the built-in SQL tools may be able to repair them, or may not. If not, it's unlikely that a 3rd party...
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
August 31, 2008 at 1:13 pm
Steve Jones - Editor (8/31/2008)
You should probably read the security sections in Books Online to understand this.
This in the wrong place?
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
August 31, 2008 at 10:07 am
Steve Jones - Editor (8/31/2008)
You can always call Microsoft PSS and perhaps they can help you with getting some data
They won't help with that. I helped out with an unrecoverable...
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
August 31, 2008 at 9:35 am
Do you want help with the DB portion, the VB portion or everything? Can you show us what you have so far? (table structures at the least)
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
August 31, 2008 at 3:36 am
Did you get the error exactly like that, with the %ls in it?
I hope you have a backup. That kind of corruption isn't repairable and with a damaged file header...
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
August 31, 2008 at 3:14 am
Even the update ran on only one thread. Both the cursor and the update maxed one of my processors for the duration.
Probably a mixture of clock speed and that possibly...
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
August 30, 2008 at 1:12 pm
rbarryyoung (8/30/2008)
It was very CPU-bound. I think that Gail's desktop is a lot better than my laptop. 🙂
Probably. I've got a fairly new quad core with 4 GB...
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
August 30, 2008 at 12:36 pm
day (8/29/2008)
Hi everyone,I was wondering has anyone competed CURSOR against INNER JOIN for bulk UPDATEs:
Some reason you can't test it yourself?
I'll bite...
Tested on SQL 2008 RTM on a desktop.
CREATE TABLE...
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
August 30, 2008 at 11:04 am
What version of SQL did that database come from? What version are you trying to attach it 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
August 30, 2008 at 2:07 am
What do you mean by slow? Queries taking longer than the should? Queries timing out? All operations (including remote desktop) slower than normal? CPU maxed out?
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
August 30, 2008 at 2:00 am
balbirsinghsodhi (8/29/2008)
You can put a shrinking log file as your maintenance plan but never put shrinking database in your maintenance plan.
It's strongly recommended that neither logs nor data files are...
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
August 30, 2008 at 1:58 am
eddy (8/29/2008)
So i can safely create those extra indexes and check each one of them by running a query ( set showplan on)
Not just any query, the queries that your...
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
August 29, 2008 at 2:26 pm
Viewing 15 posts - 44,761 through 44,775 (of 49,552 total)