Viewing 15 posts - 12,886 through 12,900 (of 49,552 total)
Ignore it. It's a sleep wait, meaning it's logged because some process is sleeping.
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
June 5, 2013 at 5:16 am
Post the restore 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
June 5, 2013 at 5:11 am
Are you running the queries in the correct database?
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
June 5, 2013 at 5:02 am
Sqlfrenzy (6/5/2013)
What if the GUI is connected through a different server/machine.. i.e. say from UAT/dev server. will the performance impact is same in this case?
Even worse.
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
June 5, 2013 at 2:47 am
hvermaak (6/5/2013)
How would you approach the problem to find the query or the data is affecting the environment?
Server-side trace as explained in the two articles from Simple Talk.
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
June 5, 2013 at 2:33 am
hvermaak (6/5/2013)
Open profiler,File, new trace.
Connect to your sql server.
Use the template -> select Tuning
select save to file -> choose a location with sufficient space
I would strongly recommend not running...
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
June 5, 2013 at 2:16 am
You can't change someone else's database context. Find whoever's running session 53, ask them to change to master.
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
June 5, 2013 at 2:11 am
SQL Geek (6/5/2013)
Hi SQLSACT, There is no wait only the CPu utilization is 90-100%.
CPU usage at 100% in no way indicates or suggests that there's too much network traffic.
In...
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
June 5, 2013 at 2:10 am
SQL will send the application the data that it requested, it won't send random stuff without some app querying it. If the application is requesting too much data, tune 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
June 5, 2013 at 1:01 am
I'd suggest that the performance problem is a secondary concern. That trigger will only work correctly if a single row is updated. Any time there's more than one row changed,...
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
June 4, 2013 at 11:55 pm
When you're rebuilding offline, the index will be unavailable, the rebuild process takes a schema modification lock, which blocks all access to the 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
June 4, 2013 at 11:34 pm
PHXHoward (6/4/2013)
I assumed if the writes were significantly more than reads than the index is bad.
For a nonclustered index, yes in general, but the clustered index is the table, hence...
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
June 4, 2013 at 3:35 pm
Spatial data? There's no relation between spatial data types (geometry and geography) and database snapshots.
No, there's no way to create the database equivalent of VM's differencing disks. Restore the users...
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
June 4, 2013 at 3:05 pm
Probably not.
What in those numbers suggests to you there's a problem? Looks just like heavily modified tables.
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
June 4, 2013 at 3:03 pm
The SSMS debug 'feature' requires that the person using it is sysadmin.
To be honest, that 'feature' is probably one of the worst debuggers around, there are much better ways 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
June 4, 2013 at 3:02 pm
Viewing 15 posts - 12,886 through 12,900 (of 49,552 total)