Viewing 15 posts - 47,056 through 47,070 (of 49,552 total)
You need the /pae switch (to enable AWE memory at the OS level), but you do not want the /3GB switch (which limits the kernel to only 1 GB of...
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
March 29, 2008 at 12:49 pm
For next time it happens (or for anyone else reading)
Detach the database. Move the transaction log to a drive that does have some space. Reattach the database. You can't backup...
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
March 29, 2008 at 12:40 pm
I'm still curious what you're doing with these created tables. Are the sales people selecting from them (and if so, can you change the queries they use)? Are you exporting...
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
March 29, 2008 at 12:35 pm
One change in SQL 2005 is that profiler records durations in microseconds, not milliseconds like 2000 did.
By default the gui still shows in milliseconds, but behind the scenes (for filters...
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
March 28, 2008 at 6:59 am
For something this simple, CLR will probably be comparable or slower, but do test for yourself. Where CLR shines is for really complex regex functions
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
March 28, 2008 at 6:54 am
MissN (3/28/2008)
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
March 28, 2008 at 6:37 am
Are you doing this to learn CLR? If not, you can create exactly the same proc in T-SQL using the REPLACE command
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
March 28, 2008 at 6:29 am
It's not new 2005 features, but the Update ... FROM will probably help here.
update MyTable
set MyTable.SumValue1= SumOfValue1,
MyTable.SumValue2= SumOfValue2
FROM
(SELECT...
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
March 28, 2008 at 3:57 am
Could you be a little more specific please? What kind of threats are you thinking about?
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
March 28, 2008 at 2:51 am
Ignacio A. Salom Rangel (3/27/2008)
GilaMonster (3/27/2008)
You may also want to run perfmon during one of these slow downs, see if any counters are wildly different from...
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
March 28, 2008 at 1:57 am
webrunner (3/27/2008)
OK, thanks! Database A (the one at the 80 level) is a SQL 2000 database that was restored onto SQL 2005,
Make sure that you update the statistics. The...
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
March 27, 2008 at 3:18 pm
Regarding your slow downs...
When the server goes slow, check the sys.dm_os_waiting_tasks DMV, see if queries are waiting and, if so, what it is that they are waiting for.
You may...
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
March 27, 2008 at 3:09 pm
Read committed is the default isolation level for SQL Server. There's no need to set it explicitly
If a query uses read committed and tries to read a row that's being...
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
March 27, 2008 at 3:04 pm
284MB for the plan cache on a server with 16 GB is nothing. I really wouldn't worry.
What are your server's max and min memory settings? Anything else on the server?
The...
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
March 27, 2008 at 3:00 pm
Did you install the SQL 2005 database engine, or just the workstation tools?
If you have 2005 and SQL 2000 on one machine, then 2005 is most likely installed as a...
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
March 27, 2008 at 2:53 pm
Viewing 15 posts - 47,056 through 47,070 (of 49,552 total)