Viewing 15 posts - 2,806 through 2,820 (of 49,552 total)
PAE and more memory won't help at all. The problem is that you're running 32-bit SQL 2000.
Is upgrading to something released this decade on the cards?
If not, then you'll need...
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
July 15, 2016 at 7:33 am
User 2 will be blocked, as User1 will be holding exclusive locks on the table until the update is complete. User 2's select won't run until User 1 has completed...
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
July 15, 2016 at 4:18 am
https://support.microsoft.com/en-us/kb/2002606
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
July 15, 2016 at 4:00 am
You don't need to understand the inner details of why the faster function is faster to use it. Just grab it from the end of the article and replace 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
July 14, 2016 at 7:17 am
Sure. Query sys.database_files (change database context to TempDB first) or sys.master_files and filter for database_id = 2
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
July 14, 2016 at 7:03 am
Grant Fritchey (7/14/2016)
Assuming those are the top 3 waits, yeah, you have page latch issues.
I'm not so sure. The average wait time is around 5ms for the SH, 1.5ms for...
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
July 14, 2016 at 6:50 am
Over what time period were those values accumulated?
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
July 14, 2016 at 6:44 am
Perfectly normal.
The binding order for columns within a subquery are:
1) Tables in the subquery
2) Tables in the outer query
Only if the column is not present in either will...
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
July 14, 2016 at 3:27 am
Open the SQL error log, find all the errors relating to that database, post them here. Do nothing else at this point.
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
July 14, 2016 at 3:17 am
CALs aren't monitored by SQL Server, but if you get audited...
25 CALs means you have max 25 people accessing that server. If you have more than that, and you get...
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
July 13, 2016 at 8:09 am
See my above reply for what you need to do in order to be able to get the information. For 5, I think you're going to need an extended event...
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
July 13, 2016 at 7:53 am
1) SELECT name from sys.procedures
2) SQL does not keep history of this information. You'll need to set up an extended events session to track this going forward
3) Short term history...
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
July 13, 2016 at 7:09 am
Database admin(DBA) (7/11/2016)
It seems like its not related to CPU issue nor memory issue.i beileve its related to SQL Latches and their indicate like performance issue.
Performance tuning shouldn't be...
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
July 12, 2016 at 4:04 am
Traces are per-instance.
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
July 11, 2016 at 4:37 am
Start by identifying the queries/procedures which frequently get timeouts.
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
July 11, 2016 at 3:16 am
Viewing 15 posts - 2,806 through 2,820 (of 49,552 total)