2021-04-09 20:51
As your instance experiences higher traffic along with concurrent usage, it may run out of worker threads needed to process session requests. This means that sessions will be waitin… Read More
Blog Directory > Technology Blogs > Spotlight Cloud technology Blog >
Spotlight Cloud Blog
spotlightcloud.io/blog
Tags:
sql server
database
performance
purchase
average
performance bottlenecks
worker threads
business
bottlenecks
threads
SQL Server News & Tips
2021-03-02 20:35
Is your server suffering from an excessive number of I/O alerts? If so, should you be worried about server performance degradation? How to best diagnose the underlying issue and sma… Read More
2020-11-05 09:00
Quest Software is excited to announce our extended Spotlight® Cloud offering which will deliver deep performance diagnostics to both on-premises and cloud SQL Server environment… Read More
2020-09-01 14:00
Today’s enterprises rely on databases to drive many business-critical processes. With technology at the core of almost every aspect of the business and IT infrastructures that… Read More
2020-08-11 15:00
When servers are down, it can lead to interruptions to your business objectives and result in loss of revenue. For example, an airline might not be able to book flights for customer… Read More
2020-08-04 15:00
Once upon a time, database administrators (DBAs) were primarily in charge of standing up and maintaining the company’s database. The end.
Today, DBAs are breaking free of the… Read More
2020-07-28 15:15
There is an online college bookstore app where many students can purchase books. Every time a student logs on, it shows a list of suggestions based on their previous purchase histor… Read More
2020-07-21 15:00
Poor database performance is a thorn in every DBA’s side. And it isn’t always easy to isolate the root cause of performance issues, which only adds to the stress. … Read More
2020-07-14 15:15
When a user or application makes requests to a database, it consumes resources on that system. As the number of requests increases, you may experience resource waits. These waits le… Read More
2020-07-07 15:00
For database administrators in charge of responding to SQL Server alerts at all hours of the day and night, the feeling of being overloaded is likely exacerbated by the constant bar… Read More
2020-06-30 15:00
Complex SQL queries are excellent for making database searches very specific and flexible, but they can also be hard to understand and almost impossible to debug—and you might… Read More
2020-06-23 15:00
Application and system performance play a huge role in how a user perceives your product’s value and your company’s competence. If the same page constantly times out or… Read More
2020-06-16 15:15
System outages and failures are painful for DBAs, but even more so for customers. Today’s users expect nearly 100 percent availability, and anything less is cause for irritati… Read More
2020-06-09 15:00
Moving your SQL Server databases from on-premises to the cloud is a solid plan if you’re looking to increase scalability, flexibility, and cost savings. But before you make th… Read More
2020-06-04 13:00
We are excited to announce that Spotlight Cloud now supports Azure SQL DB in a preview mode! Read More
2020-06-02 15:00
When the dust starts to settle after COVID-19 and we begin to move the economy forward, enterprises will be looking for the best infrastructure to keep their data secure, scalable… Read More
2020-05-26 15:00
More and more organizations are recognizing the benefits of moving from a solely on-site database infrastructure to a cloud or hybrid cloud infrastructure. Cloud computing platforms… Read More
2020-05-19 15:00
In today’s cloud-powered, data-driven economy, database administrators are finding their role in a state of flux. With the increasing levels of automation, the growing popular… Read More
2020-05-12 15:00
Data is king in today’s economy, and DBAs are on the front line of data security and protection. Because of the sensitive nature of the work, database administration requires… Read More
2020-05-05 15:00
Database systems are a lot like people: They are complex and multi-layered, and they don’t always behave well under stress. That’s where SQL Server performance monitorin… Read More
2020-04-28 14:45
Adopting good SQL syntax and query-writing practices will improve your database monitoring efficacy and, as a result, improve your overall database performance. There are several tr… Read More
2020-04-23 14:28
As a SaaS product, Spotlight Cloud Professional is constantly updating so that users have access to an optimal tool. We regularly release new features that make our database perform… Read More
2020-04-21 14:44
You’ve seen this wait type before, haven’t you? Well, it is certainly a wait type that has caused lots of confusion. The immediate focus is generally given to the word … Read More
2020-04-16 14:56
In this article, we will discuss several issues that you may face while creating, configuring or maintaining an Always on Availability Group site Read More
2020-04-14 15:00
Historically, cloud-based database monitoring solutions have been viewed with a high level of suspicion. In an age when security breaches are becoming more frequent and more severe… Read More
2020-04-09 13:45
SQL Server provides us with a number of high availability and disaster recovery solutions that help in making the data that serves the critical systems available for the longest pos… Read More
2020-03-31 18:15
I was chatting with a consultant friend a couple of weeks ago. His main role at the moment is working on projects moving SQL Server databases to the cloud (AWS and Azure) and on mas… Read More
2020-03-31 15:15
Getting management’s attention is a good thing, if it happens for positive reasons. But many database administrators would actually prefer to stay off of the radar. Because DB… Read More
2020-03-26 13:30
In the previous article, Setting Up and Configuring SQL Server Replication, we discussed in-depth, the SQL Server Replication concept, its components, types and how to configure the… Read More
2020-03-24 15:00
SQL Server 2019 is the latest public release of SQL Server. SQL Server 2019 builds upon and improves some of the features introduced in earlier versions of SQL Server and also intro… Read More
2020-03-19 14:57
SQL Server Replication is one of the data synchronization features that is used to copy and distribute the SQL Server database objects and data between the databases located in the… Read More
2020-03-17 15:00
DBAs play a vital role within an organization. As custodians of data, they are responsible for managing all aspects of database performance, including high availability, fast query… Read More
2020-03-10 15:00
Data is practically currency in today’s business arena, making corporate databases one of your most valuable assets. With the number and severity of breaches growing rapidly… Read More
2020-03-06 15:15
Microsoft Azure provides Platform as a Service (PaaS) Database Engine through the Azure SQL Database platform, so that we can use this database for the cloud-based applications. The… Read More
2020-03-03 16:15
Database administrators have a lot of responsibilities, from general database management to capacity planning to ensuring high availability and disaster recovery. With so many irons… Read More
2020-02-25 16:00
Effective SQL Server performance monitoring is critical to maintaining optimally functioning database systems, no matter how large or small the organization.
If you are reading thi… Read More
2020-02-18 16:00
The start of a new year is a great time to take stock of your processes and tools. Taking inventory of what’s working, what isn’t, and where can you make improvements he… Read More
2020-02-11 16:00
There are many reasons why applications might be slow to respond, but if users are complaining about performance, you may be dealing with a SQL Server deadlock. Fortunately, there a… Read More
2020-02-04 16:15
When something goes wrong in your T-SQL, you want to fix the problem quickly with minimal digging around and disruption to users. SQL Server-generated error messages are highly tech… Read More
2020-01-28 16:00
In today’s technology-driven world, there are few parts of our lives that don’t depend on software and IT-related functions. As we have become more reliant on technology… Read More
2020-01-21 16:00
SQL Server index fragmentation is a common source of database performance degradation. Fragmentation occurs when there is a lot of empty space on a data page (internal fragmentation… Read More
2020-01-16 14:57
Database indexes are used to improve the speed of database operations in a table with a large number of records. Database indexes (both clustered indexes and non-clustered indexes)… Read More
2020-01-13 15:57
Spotlight Cloud Reports use up to a year’s worth of data to produce long-term trend analysis on your database. Professional Subscription users can take advantage of these repo… Read More
2020-01-09 18:57
Database indexes are used to speed up different table operations. However before you create an index, it is important to know if you really need an index? And if you need to create… Read More
2020-01-07 15:45
SQL query execution plans are generated when a query optimizer determines the most efficient way to deliver the data requested by a query. These plans are a representation of … Read More
2020-01-06 15:56
As you may be aware, SQL Server replication is a technology for copying and distributing data and database objects from one database to another, and then synchronizing between datab… Read More
2019-12-30 16:00
There are a lot of options when it comes to selecting a database performance monitoring tool. To ensure you are using the best tool for your organization, you first need to make sur… Read More
2019-12-19 14:59
Machine learning databases are now coming of age. This presents huge opportunities for database professionals who are able to evolve to take advantage of this change. Read More
2019-12-17 16:15
Database performance issues manifest in a variety of ways—from slow loading pages to timeouts to excessive memory usage to full-on outages. Often, performance monitoring tools… Read More
2019-12-10 16:00
High-performing, high-availability databases are every SQL Server DBA’s goal, but the reality is that database performance isn’t always optimal. Slow response times, tim… Read More
2019-12-09 18:53
Spotlight Cloud Reports is a new feature that assists with your long-term trend analysis for your SQL Servers and Windows servers Read More
2019-12-06 14:59
Note that this feature will be enabled by default on all Spotlight Cloud accounts starting from December of 2019. Users can opt to disable this feature in the on-premise configurati… Read More
2019-12-05 14:52
Each SQL Server instance contains the system SQL Server database called TempDB. It is typical for all database connections, and almost every query makes usage of the TempDB database… Read More
2019-12-03 16:15
SQL Server blocking is a normal trait of SQL Server database systems. Blocking occurs when SQL Server is servicing requests from multiple clients and different processes request the… Read More
2019-11-26 15:45
If your database users have been grumbling that SQL Server performance has been lackluster lately, it’s possible you are experiencing the effects of one or more SQL Server bot… Read More
2019-11-19 15:45
There are dozens of lists out there defining the “Top X Ways to Be an Awesome DBA.” A lot of the lists are a mix of soft skills and technical skills, which is helpful, e… Read More
2019-11-12 16:15
Database performance issues aren’t uncommon. Fortunately, there is usually a fairly intuitive solution to most problems. The most important thing a DBA can do to fix issues qu… Read More
2019-11-05 15:30
SQL Server performance monitoring is considered by many database administrators to be their most important responsibility. Given that poorly performing servers can negatively impact… Read More
2019-10-29 15:15
Maintaining high-performing SQL Server instances is a huge portion of a DBA’s job responsibilities. Failure to detect and correct unusual activity can affect internal operatio… Read More
2019-10-22 15:15
SQL Server database administration is usually a one-person job. The day-to-day work of a database administrator (DBA) involves specialized, precise, and specific tasks that can&rsqu… Read More
2019-10-15 14:15
Database monitoring technology is in a constant state of motion. This can present some challenges for DBAs who need to stay on top of the latest tools and trends to keep their ins… Read More
2019-10-08 15:10
Maintaining a high-performing SQL Server is essential not only to your organization’s operations but also to your customers. When your servers are slow to respond—or don… Read More
2019-10-03 14:28
Continuous learning in a business context is the practice of seeking out knowledge and information that will help you do your job better, expand your skill set, and add value to the… Read More
2019-10-01 14:29
RIP SQL Server 2008 support. Unless you do your DBAing from under a rock, you probably already know that Microsoft ended support for SQL Server 2008 over the summer Read More
2019-09-24 15:03
Whether you are new to the DBA role or you are a seasoned veteran, there is always a way to improve or streamline your performance monitoring process. Here are 10 facts about data… Read More
2019-09-19 13:50
It’s 3 a.m. and suddenly your phone blows up with alerts. Something really bad must have happened to the server. Only it didn’t. It’s another false alarm—the… Read More
2019-09-17 14:13
Whether you are new to database administration or just to this particular job, the first thing you’ll need to do when you take on a new DBA position is audit the current serve… Read More
2019-09-12 15:12
Database administrators wear a lot of hats behind the scenes—from capacity planning to security to data recovery. Perhaps the most visible of the DBA’s responsibilities… Read More
2019-09-03 15:21
In today’s digitally driven world, reliability, availability, and performance of databases are the crux of an organization’s success. With the weight of these responsi… Read More
2019-08-28 14:57
It is always encouraged when writing queries or SQL Server database code (procedures and views) to take notice of the execution plan. There are several reasons for this. Firstly &nd… Read More
2019-08-21 15:04
First and foremost, what is a Deadlock? A Deadlock occurs when two or more transactions block each other’s progress because one transaction has a lock on a database object the… Read More
2019-08-14 21:33
Do you ever compare your work slinging SQL as a database administrator to shifting gears with a manual transmission? In a world conquered long ago by the graphical user interface (G… Read More
2019-07-25 15:17
Budget is precious nowadays. It’s tough to get budget for headcount, but sometimes it is surprisingly easy to get budget for tools. Good tooling can really take the pressure o… Read More
2019-07-22 14:57
Before you start to look at tooling, think about your specific environment: Read More
2019-07-18 14:54
Once you have established a list of SQL servers in your environment, you will want to ask some critical questions: Read More
2019-07-15 15:06
There is a growing number of great SQL Server performance monitoring systems out there. Recently, the more traditional on-premises solutions have been joined by software as a servic… Read More
2019-06-27 14:20
There is no shortage of benefits to moving to the cloud, but there are three main reasons people are increasingly adopting Software-as-a-Service (SaaS) solutions: infrastructure, sc… Read More
2019-06-10 15:02
Today, I'm going to walk through an exciting new feature called "Playback" that we've added to Spotlight Cloud Read More
2019-06-06 14:03
Database administrators often find it difficult to articulate their value to an organization. This is surprising given that almost every part of today’s businesses are driven… Read More
2019-05-31 15:03
Spotlight Cloud Basic is a SQL monitoring subscription that provides free access forever, for up to five SQL Servers and five host operating systems. You can monitor each of those S… Read More
2019-05-15 14:09
Query profiling is how you figure out what’s going on inside the black box of SQL Server performance Read More
2019-05-07 15:10
What if you went to all the trouble of implementing or upgrading to a new SQL Server for a better experience for your customers — and they complained that things were actually… Read More
2019-04-30 15:17
“Doc, I’m worried about my SQL Server performance.” Read More
2019-04-24 15:49
“We’ve got some SQL Server performance bottlenecks to deal with,” said my boss, late one Friday Read More
2019-04-17 15:24
We all know that the way data is gathered, processed, and stored is always changing. We also know the amount of data stored in databases is continually growing…fast! The role… Read More
2019-04-09 15:13
Page Life Expectancy as a metric has been discussed in SQL Server for quite a long time now and it is still considered a key performance indicator for those DBAs looking at the over… Read More
2019-04-03 15:00
On March 21st, 2019, Quest released a new version of the SQL Server Management Studio (SSMS) plugin, Spotlight Tuning Pack Read More
Subscribe to Spotlight Cloud
Get updates delivered right to your inbox!