Viewing 15 posts - 30,856 through 30,870 (of 49,552 total)
The first thing to note is that the max server memory is not what SQL will use. It's the max that it's allowed to use. If it's not busy, it...
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
September 8, 2010 at 9:49 am
Also, what version of SQL?
SELECT @@version
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
September 8, 2010 at 9:36 am
LutzM (9/8/2010)
I've seen this very same question (including exactly the same query even down to POPDATA.ANCNUMBER=720) at least a dozen times so far.
Links?
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
September 8, 2010 at 9:34 am
One question answered, two to go.
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
September 8, 2010 at 9:27 am
We're not going to do your homework for you. Advice, sure, but not a complete solution.
First things first... Does Access have a CASE or SWITCH type statement? I'm pretty sure...
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
September 8, 2010 at 9:19 am
Is the OS x86 or x64? Is SQL x86 or x64?
How are you measuring that 1GB memory usage?
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
September 8, 2010 at 9:15 am
Yes.
Query sys.dm_db_index_physical_stats. Look at the page_count column. A page is 8kb.
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
September 8, 2010 at 8:27 am
SQL won't release memory unless the OS is under memory pressure. That's normal and that's how it works.
With 8GB on an x64 server you should set max memory no higher...
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
September 8, 2010 at 8:26 am
Paul White NZ (9/8/2010)
GilaMonster (9/8/2010)
Which is going to reach 20 000 posts first, me or the Thread?You, by quite some margin.
If thread stays at current activity, I roughly guestimate it'll...
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
September 8, 2010 at 8:18 am
Well, you could write some code to throw those errors and see what error numbers they have.
The SQL errors are visible in the sys.messages view. Query that, see what errors...
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
September 8, 2010 at 8:04 am
Now here's an interesting question...
Which is going to reach 20 000 posts first, me or the Thread?
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
September 8, 2010 at 7:53 am
Noise level. (as in too high)
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
September 8, 2010 at 7:46 am
Use a TRY-CATCH block, use the Error_Number() function to check what the error code is, then use RAISERROR to raise a custom error back to the app.
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
September 8, 2010 at 7:38 am
ALZDBA (9/8/2010)
Hi Gail, Sorry for hopping in but would this be a typical case of VLF fragmentation ?
That is what I said earlier.
GilaMonster (9/8/2010)
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
September 8, 2010 at 6:27 am
No it is no recommended to run that.
Take a look through this article - http://www.sqlservercentral.com/articles/64582/
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
September 8, 2010 at 6:26 am
Viewing 15 posts - 30,856 through 30,870 (of 49,552 total)